Amsterdam, NLUnderstanding how DAX evaluates IF statements
Marco Russo & Alberto FerrariIn 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
Jul 9-11 - Seattle
Aug 19-21 - Toronto
Oct 1-3 - London
Oct 28-30 - Lugano
Video Training
Introducing DAX Video CourseFree
Understanding the “can’t determine relationship between the fields” error in Power BI
This article explains why you might encounter a curious error when placing columns from unrelated tables in a Power BI matrix. Read more
Direct Lake vs Import vs Direct Lake+Import | Fabric semantic models (May 2025)
Marco RussoWhen I presented “Choosing Between Import Mode, Direct Lake, and Composite Models” at Fabric Conf 2025 in Las Vegas, the room overflowed, and the session was not recorded. I promised to publish the material once the new Direct Lake + Import composite model… Read more
DAX Patterns
Semi-additive calculations
Calculations reporting values at the start or the end of a time period are quite the challenge for any BI developer and DAX is no exception These measures are not hard to compute the complicated part is understanding the desired… 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