Measure Settings Dialog Box (Standard Aggregation)
Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.
The Measure Settings dialog box lets you create or change a measure that uses a standard aggregation. To access this dialog box, in the Excel window, in the PowerPivot Field List, in the Values pane, right click a field, and then click Edit Measure.
A measure is a custom, dynamic calculation that you can create, and it is stored together with the data. Anyone who uses the PowerPivot workbook can see the measure and use it in calculations. For more information about measures, see Create a Measure in a PivotTable or PivotChart. Standard aggregations are those that are based on SUM, COUNT, MIN, MAX, and AVERAGE, which are the aggregations that you can create in a standard Excel PivotTable.
You can also define custom aggregations by using the Data Analysis Expressions (DAX) formula language, but you cannot design custom formulas by using this dialog box. For more information, see Create a Measure in a PivotTable or PivotChart.