Latest from the blog.
Deep-dives on DAX, filter context, and the skill Copilot can’t fake — from the team building the rig.
Power BI Relationship Not Working? 9 Checks Before Rewriting DAX
If a Power BI relationship is not working, verify keys, data types, cardinality, active paths, filter direction, blank rows, dates, and visual…
DAX Context Transition Explained: Why CALCULATE Changes the Result
Understand DAX context transition with small examples that show how CALCULATE turns current row values into filters—and where that transition…
How to Use a DAX Playground to Test Measures Online
Use a DAX playground as a testing lab: define the grain, predict results, vary filter context, test totals, and save the cases that teach you…
Power BI Percent of Total Is Wrong? ALL vs ALLSELECTED
Fix a wrong Power BI percent of total by defining the denominator, choosing ALL or ALLSELECTED, and testing rows, subtotals, slicers, and grand…
10 DAX Practice Exercises With Solutions
Practice DAX with 10 original exercises and worked solutions covering measures, CALCULATE, filter context, iterators, totals, and time…
Understanding Row Context vs Filter Context in DAX
Understand how row context and filter context differ in DAX, when context transition happens, and why the same formula changes across a Power…
DAX CALCULATE and Filter Context: 8 Practice Problems
Learn how DAX CALCULATE changes filter context with eight practical problems covering replacement, intersection, filter removal, relationships…
DAX Syntax Checker: What It Catches—and Misses
A DAX syntax checker can catch parsing errors, but not wrong grain, filter context, totals, model relationships, performance, or business…
SELECTEDVALUE Returns Blank? 7 Checks That Fix It
When SELECTEDVALUE returns blank, check distinct values, evaluation timing, visual context, relationships, query filters, data quality, and…
Stop reading. Start writing.
The best way to understand CALCULATE is to miss a test case. Pick a challenge and go.