Start free
Explain my measure

See exactly what your DAX is doing.

Paste any measure. Get a SQLBI–style walkthrough — pills, row context, context transition, filter modification — rendered exactly how Marco and Alberto draw them in their articles. No signup. Every walkthrough is sharable.

The problem

SQLBI explains it once. Then you have to apply it to your measure.

Marco and Alberto’s articles on row context, filter context, and context transition are the canonical DAX explainers. They’re visual, they’re honest about the cliff, and they’re written for the right audience — you.

The catch is they explain the concept with their measure, against their data model. When the measure that’s confusing you isn’t Marco’s, you have to translate.

This tool removes the translation step. You paste your measure. We render the same diagrams, applied to your measure, with your tables and your iterations and your filter pills.

YOUR MEASURE
Sales per Customer = AVERAGEX( VALUES(Customer[CustomerKey]), [Sales Amount] )
DETECTED: row context · context transition · aggregation · recap
01 — Paste

One textarea. No setup.

Drop a measure in. The page tells you immediately which of the six SQLBI concepts apply — starting filter context, row context, context transition, filter modification, aggregation, recap — before you commit.

Don’t have a model? That’s fine. Measure-only mode renders the same structural walkthrough with placeholder values. Bind a built-in model or upload a .pbit to see real numbers fill in.

Starting filter context
Row context (iterator detected)
Context transition
·Filter modification — not in this measure
Aggregation
Recap
02 — Walk through it

The same diagrams Marco draws — on your measure.

The walkthrough renders six section types using SQLBI’s exact visual language: hand-drawn marker pills, pastel blue for the source context, pastel orange for the target context, red X over removed filters, the canonical “disassembly” from a row context to N filter context pills for context transition.

It’s deterministic. No LLM in the loop. Every number, every pill, every X is produced by introspection against the bound model — or labelled symbolic when there isn’t one.

Date[Year]
2024
Region[Name]
North
✎ Filter Context
Coming next

Slicer Builder — filter a report by a measure threshold.

A sibling tool built on the same SQLBI pedagogy — for the “I want a slicer to filter by sales amount” case Marco rebuilt in his article on filtering measures through slicers. Granularity-aware, calculation-group powered.

Notify me when it ships →

Ready to walk through your measure?

No signup. Every walkthrough is sharable. Paste a measure from a forum, paste a measure from your own model — either way you get the same SQLBI-style explainer in seconds.

Explain a measure →