As we saw in Chapter 1, What is DAX?, measures are a way of creating aggregations of data using a DAX expression. A measure always involves some form of aggregation, such as calculating the sum of a numeric column, for example, the sales amount. Measures invariably involve more complex DAX expressions than a calculated column or calculated table. You also need to take the evaluation context into account.
Before we start creating any measures, we will create a measures table to store them. Again, this is something we can do in Power BI Desktop, but not Excel Power Pivot. We'll look at creating measures in Power Pivot and SSAS Tabular in the next chapter.
From the Power BI Desktop, do the following:
- Switch to the Report or ...
