Shared walkthrough

Explain my measure

An interactive SQLBI-style walkthrough of the measure below. The full diagrams — pills, row context, context transition, filter modification — render in the interactive view.

Open interactive walkthrough → Explain your own measure

The measure

What this walkthrough explains

Sales Ignoring Category Filter =
CALCULATE(SUM(Sales[Sales Amount]), REMOVEFILTERS(Product[Category]))

Walkthrough covers

The SQLBI concepts in this measure

✓Starting context ·Row context ·Context transition ✓Filter modification ✓Aggregation ✓Recap

See the full diagrams in the interactive view.

Hand-drawn marker pills, the row-context-to-filter-context disassembly, red X over removed filters — all the SQLBI visual language, applied to this measure.

Open interactive walkthrough →