Model
0 0 About
Lesson 05 of 7 · Measures

A measure stores a formula, not a number.

All 219 measures live in one table with no data in it. Each one is worked out fresh for every cell it lands in.
1

A table with no data in it

All 219 measures live in one table, _Measures. It holds no rows and has no relationships. It exists so every measure has one home, and the Fields pane shows them in one place instead of scattered across fact tables.

A measure doesn't store a result. It stores a formula, and Power BI works it out for each cell of a visual, using whatever filters apply to that cell. That set of filters is the filter context.

Total tonnes sits in a matrix: commodities down the side, years across the top, with totals. How many times is it calculated?

Answer the question above to unlock this.
Total tonnes = SUM ( Trade[Tonnes] )

This cell's filter context

Result –Cells tried: 0 of 3

Click any number, including a total. A toy table with illustrative values.

2

Every measure has a register row

A number on a tile is only useful if people know what it counts. So every measure shown on a tile has a row in the measure basis register, the DimMeasureBasis table, with six fields:

StageWhere in the value chain
Unitt, kt, €, %
ScopeWorld or EU, which items
PeriodYear, month, rolling
SourceWhich dataset
StatusHow far it's been checked

The short explanation behind each tile's information button is a measure too. It reads its text from the register, so the wording lives in one place.

0 / 2
An inventory finds that 42 of the 219 measures aren't used by any visual. What's the right next step?
Where does a new measure go?
The ruleMeasures live in one home table. Every measure on a tile has a register row saying what it counts, in what unit, over what period, and from which source.