Topic: DAX
-
This article describes how variables should be used in DAX expressions involving IF and SWITCH statements in order to improve performance. Read more
-
This article describes how to create a measure displaying the name or value of an element that has a specific ranking, with different option for managing ties. Read more
-
This article describes the behavior of auto-exist in DAX, explaining the side effects of combining slicers on columns of the same table in Power BI. Read more
-
This article describes possible optimization approaches to improve the performance of nested iterators in DAX. Read more
-
This article describes how to use a measure to filter a Power BI visualization, and the different behaviors of a same filter between different visuals. Read more
-
This article describes how to optimize DAX expressions with mutually exclusive calculations that might cause slow query performance. Read more
-
In SQL there are different types of JOIN, available for different purposes. This article shows the equivalent syntaxes supported in DAX and it was updated in May 2018. Read more
-
This article describes the behavior of the COMBINEVALUES function in DAX, and how it can optimize the performance of DirectQuery with multi-column relationships. Read more
-
Expanded tables are the core of DAX; understanding how they work is of paramount importance. This article provides a theoretical foundation of what expanded tables are, along with fundamental concepts useful when reading DAX code. 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