This article is about how rules like “avoid pie charts” can be useful for beginners, but also unhelpful in real-world scenarios with more nuance. Instead of learning rules about “how”, try to understand the “why”. Read more
This article describes the differences between the ALL and CROSSFILTERED functions in DAX. ALL CALCULATE modifier Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. ALL (… Read more
This article describes how to optimize inventory calculations in DAX by using snapshots to avoid the computational cost of a complete running total. Read more
After another year, it is time to recap what happened in the DAX and SQLBI worlds and provide a few spoilers about 2025! Read more