Topic: Filter Context
-
SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. Read more
-
Data lineage is such a well-implemented DAX feature that most developers use it without knowing about it. This article describes data lineage and how it can help in producing better DAX code. Read more
-
This article describes how the SELECTEDVALUE DAX function simplifies the syntax required in many scenarios where you need to read a single value selected in the filter context. Read more
-
In Power BI Desktop (as of February 2016) you have to use DAX to apply calculations over dates (such as year-to-date, year-over-year, and others), but you do not have the Mark as Date Table feature. This article describes which scenarios… Read more
-
This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When used as filters in CALCULATE, ALLxxx functions might display unexpected behaviors. Read more
-
This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or FILTER. Read more
-
This article describes how to display the filter context applied to a calculation using a special DAX measure in Power BI Tooltips. Read more
-
ALLSELECTED is a powerful function that can hide several traps. This article is an in-depth analysis of the behavior of ALLSELECTED, explaining shadow filter contexts, what they are and how they are used by ALLSELECTED. Read more
-
This article explains how the context transition interacts with the filter arguments of a CALCULATE function in DAX. This is important in order to avoid unexpected results with complex calculations made in filter arguments. Read more
-
This article describes how table expansion and filter context propagation are important DAX concepts to understand and fix small glitches in DAX expressions. Read more