Toronto, ON, CAALLSELECTED best practices
Marco Russo & Alberto FerrariALLSELECTED 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
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
Dec 2-4 - Amsterdam
Oct 1-3 - London
Oct 28-30 - Lugano
Video Training
Introducing DAX Video CourseFree
Understanding how DAX evaluates IF statements
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
Controlling empty or multiple selections in calculation groups
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
DAX Patterns
Standard time-related calculations
In this pattern we show you how to compute time-related calculations like year-to-date same period last year and percentage growth using a standard calendar The great advantage of working with a standard calendar is that you can rely on several… More on DAX Patterns
SQLBI Corp.
Optimizing DAX, Second Edition
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