Measure Settings Dialog Box (Standard Aggregation)

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on

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.

  • Table name
    Displays the name of the table where the field definition will be stored.

  • Source Name
    Displays the name of the column that contains the values to aggregate.


    If you subsequently delete the column, the measure will be deleted as well.

  • Custom name
    Type a display name that you can use for the aggregation. The display name is used only in the current PivotTable or PivotChart.

  • Choose how you want the selected field to be aggregated
    Choose the type of calculation that you want to use. The values in the field are then calculated and placed in the PivotTable or PivotChart.

    Standard aggregations:






  • Measure will use this formula
    Displays the DAX formula that is generated by the selections.

See Also


Measures in PowerPivot

Create a Measure in a PivotTable or PivotChart

Take a Tour of the PowerPivot UI