Microsoft Office Tutorials and References
In Depth Information
Alternatively, you can also right-click a table name in the PowerPivot Field List, choosing the
Add New Measure menu item, as shown in Figure 3-11.
FIguRE 3-11 The Add New Measure menu item on the context menu on a table in the PowerPivot Field List.
At this point, the Measure Settings dialog box (see Figure 3-12) opens and you can choose
the table name that contains the new measure, the name of the measure (which can be
customized for each PivotTable), and finally the DAX formula.
FIguRE 3-12 Measure Settings displayed to create a new measure.