Lesson 7: Create Measures In this lesson, you will create
measures to be included in your model. Similar to the calculated
columns you created in the previous lesson, a measure is
essentially a calculation created using a DAX formula. However,
unlike calculated columns, measures are evaluated based on a
filter; a user selection, for example, a particular column or
slicer added to the Row Labels field in a PivotTable. A value
for each cell in the filter is then calculated by the applied
measure. Measures are powerful, flexible calculations that you
will want to include in almost all tabular models, to perform
dynamic calculations on numerical data. To learn more, see
Measures (SSAS Tabular). To create measures, you will use the
Measure Grid. By default, each table has an empty measure grid;
however, you typically will not create measures for every table.
The Measure Grid appears below a table in the model designer
when in Data View. To hide or show the measure grid for a table,
click the Table menu, and then c