Topic: Filter Context
-
DAX offers many functions to remove filters from the filter context. In this article, we analyze the differences among the most commonly-used functions. Read more
-
ALLSELECTED is a powerful, yet dangerous function. This article describes the best practices to follow to avoid falling into the pitfalls involved with ALLSELECTED. Read more
-
This article describes the differences between the ALL and CROSSFILTERED functions in DAX. Read more
-
This article describes the DAX context transition using a conceptual model based on a visual representation. Read more
-
One of the few golden rules in DAX is to always filter columns and never filter tables with CALCULATE. This article explains the rationale behind the rule. Read more
-
This article describes the DAX filter context using a conceptual model based on a visual representation. Read more
-
This article describes the best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. 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
-
The context transition in DAX is the transformation of row contexts into an equivalent filter context performed by CALCULATE and CALCULATETABLE. Managing this behavior is the next step in learning DAX once you understand row context and filter context. This… Read more
-
A filter argument in CALCULATE is always an iterator. Finding the right granularity for it is important to control the result and the performance. This article describes the options available to create complex filters in DAX. Read more