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

Average Sales Per Category =
AVERAGEX(VALUES(Product[Category]), CALCULATE(SUM(Sales[Sales Amount])))

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 →