Ever struggled with a formula in DAX that does not compute what you want? It has happened to us many times, and we know that the problem is ALWAYS related to the evaluation context. Filter context, row context, and context…  Watch now

This article describes how to display the filter context applied to a calculation using a special DAX measure in Power BI Tooltips.  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 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

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 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

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

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

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