Measure Settings Dialog Box (Standard Aggregation)

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

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.

  • 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:

    Sum

    Count

    Min

    Max

    Average

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

See Also

Other Resources

Create a Measure

Create a Measure in a PivotTable or PivotChart

Take a Tour of the PowerPivot UI