Vancouver, BC, CAContext transition in DAX explained visually
Marco Russo & Alberto FerrariThis article describes the DAX context transition using a conceptual model based on a visual representation. Read more
Filter columns, not tables, in DAX
One of the few golden rules in DAX is to always filter columns and never filter tables with CALCULATE. This article explains the rationale behind the rule. Read more
Dec 10-12 - Amsterdam
Oct 14-16 - London
Oct 30-Nov 1 - New York City
Dec 2-4 - Copenhagen
Video Training
Introducing DAX Video CourseFree
Highlighting a data point and comparing to all others in a distribution
Kurt BuhlerThis article shows how you can highlight a single value in visual when comparing the distribution of a measure for one value versus all others. Read more
Row context in DAX explained visually
This article describes the DAX row context using a conceptual model based on a visual representation. Read more
DAX Patterns
Time patterns
This post introduces the four time-related calculations patterns presented in this website The goal here is to help you choose the right pattern based on your specific needs Indeed when it comes to time-related calculations the choice of the pattern… 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