Choosing between DISTINCT and VALUES in DAX
When should you use DISTINCT over VALUES in DAX? Here is how to write resilient measures that survive bad data and model changes. Read more
When should you use DISTINCT over VALUES in DAX? Here is how to write resilient measures that survive bad data and model changes. Read more
In this article, we examine the details of executing DAX code, with a focus on how the IF function is implemented in various scenarios. Read more
This article describes how to control the execution of DAX code when there are either multiple or empty selections of calculation items in calculation groups. Read more
This article explains why you might encounter a curious error when placing columns from unrelated tables in a Power BI matrix. Read more
The like-for-like sales comparison is an adjusted metric that compares two time periods restricting the comparison to products or stores with the same characteristics In this example we use the like-for-like technique to compare the sales of Contoso stores that… More on DAX Patterns
Optimizing DAX is the state-of-the-art book on optimizing DAX expressions in Power BI and Analysis Services semantic models.
Learn how to locate performance bottlenecks, read the query plan and performance metrics, rewrite the slower part of an expression, and measure the performance improvements. Read more