Latest from the blog.
Deep-dives on DAX, filter context, and the skill Copilot can’t fake — from the team building the rig.
DAX Measure Shows the Same Value for Every Row? 6 Fixes
If a DAX measure repeats the same value on every row, test the row field, relationship path, filter-removal logic, variables, and calculation…
5 DAX Debugging Habits That Find Wrong Totals Faster
A repeatable workflow for diagnosing wrong totals, filter-context surprises, and measures that look correct until the report changes.
DAX DISTINCTCOUNT Total Is Wrong? When the Total Is Actually Correct
A DAX DISTINCTCOUNT total does not add visible rows because overlapping values are counted once in total context. Learn when to keep it and…
SUM vs SUMX in DAX: When Each Returns the Wrong Total
Use SUM for one stored numeric column and SUMX when the business rule must evaluate an expression at a defined grain. See examples, total…
USERELATIONSHIP in DAX: Fix an Inactive Date Relationship
Use USERELATIONSHIP inside CALCULATE to activate an existing inactive model relationship for one measure, such as sales by ship date instead of…
HASONEVALUE vs ISINSCOPE in DAX: Fix Matrix Totals
Use ISINSCOPE to detect the active matrix hierarchy level and HASONEVALUE to test cardinality. See why slicers make them return different…
Power BI Measure Ignores a Slicer? 7 Checks That Fix It
When a Power BI measure ignores a slicer, check visual interactions, relationships, disconnected tables, filter-removal functions, and hidden…
Power BI Date Table Not Working? 8 Time-Intelligence Checks
Fix a Power BI date table by checking uniqueness, gaps, range, data types, timestamps, relationship roles, visual fields, and time-intelligence…
DAX Grand Total Is Wrong? Why Totals Recalculate
A DAX grand total reevaluates the measure in total filter context; it does not automatically add visible rows. Learn when that is correct and…
Stop reading. Start writing.
The best way to understand CALCULATE is to miss a test case. Pick a challenge and go.