DAX

If you’ve been working with DAX for a while, there’s a high chance you’ve encountered one of the most confusing moments in the learning process. You write a formula that seems perfectly logical, yet Power BI either throws an error or returns a result that makes absolutely no sense. Then you change a single function — maybe adding SUMX or wrapping something inside CALCULATE — and suddenly everything works. At first, it feels random. In reality, it all comes down to one thing:

Learn how to transform columns into single values using powerful DAX functions like VALUES, SELECTEDVALUE, HASONEVALUE, and CONCATENATEX.

Learn the difference between SWITCH() and SWITCH(TRUE(),…) in DAX, with practical examples and use cases in both row and filter contexts.

Discover how DAX functions ALL, VALUES, and DISTINCT behave differently in filter and row context, and how they handle blank rows in PowerBI

Learn how DAX functions ALL() and ALLEXCEPT() work in Power BI, when to use them, and how they affect filter context in your measures.