New Measure Dialog Box

 

Use the New Measure dialog box to create a new set of numeric values in an Analysis Services (OLAP) cube based on a column in the fact table of the cube.

Use thisTo do this
Measure nameType a descriptive name for the new measure you are creating.
Base data itemFrom the drop-down list, select the base data item for the measure. Note: This option is available for all measures except the count measure.
SumClick to create a measure that displays the sum of all the elements in the base data item.
CountClick to create a measure that displays the total number of instances of the base activity.
AverageClick to create a measure that displays the average value of the elements in the base data item.
MaximumClick to create a measure that displays the highest-valued element in the base data item.
MinimumClick to create a measure that displays the lowest-valued element in the base data item.

How to Define Measures

Community Additions

ADD
Show: