Measured Aggregation Functions evaluates a Measure or a Custom Measure over a list of values, and aggregates the resulting values.
Syntax
AggregationType( <Value List>, <Measure> )
Parameters
<Value List> : A Dimension or a Filter
<Measure> : A Measure or Custom Measure
Description
Evaluates <Measure> for each member in <Value List> and:
| Aggregation Type | Description |
| Sum | Returns the total value |
| Avg (Average) | Returns the average value |
| Min (Minimum) | Returns the minimal value |
| Max (Maximum) | Returns the maximal value |
Example 1
Assuming [Days] is a 'Days' level of a Time Dimension and Sales is a Measure:
Avg([Days], [Sales]) will calculate average sales per day.
Example 2
Assuming [Top 5 Customers by Sales] is a Top Ranking filter and Sales is a Measure:
Sum([Top 5 Customers by Sales], [Sales]) will calculate the total sales for the 5 customers with the most sales.