Measure Settings Dialog Box (Standard Aggregation)

SQL Server 2012

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.

Note Note

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.

Note Note

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.

Community Additions