Articles of 2024
Highlighting a data point and comparing to all others in a distribution
This 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
When are variables evaluated in DAX?
This article clarifies how DAX evaluates variables, which is important to avoid common mistakes when using DAX for the first time. Read more
Using atomic design in report and model development
This article introduces the ‘atomic design methodology’ as an approach to make Power BI development more efficient and repeatable. Read more
Filter context in DAX explained visually
This article describes the DAX filter context using a conceptual model based on a visual representation. Read more
Introducing the 3-30-300 rule for better reports
This article describes a simple approach that you can apply to improve your reports and dashboards. Read more
Understanding apply semantics for window functions in DAX
This article explains the unique behavior of apply semantics: a new way of computing table expressions when multiple rows are selected in DAX window functions. Read more
SQLBI video course services for enterprise
This article describes all the options and APIs available to improve the use of SQLBI video courses in an enterprise environment. Read more
Best practices for using KEEPFILTERS in DAX
This article describes the best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Read more
The Optimizing DAX book is available
We are proud to announce the availability of our new book, Optimizing DAX. Read more