fbpx

Avg (MDX)

Compute the average value over the specified set.

Parameters

Name Type Cardinality Default value
set  set-expression  one   
value  value-expression  zero-one  [Measures].currentMember 

Return

value

Description

The avg function calculates the average value of the non-empty cells. Empty cells are ignored.

1) A value expression is specified.

When the value expression is specified, the measure is evaluated over the set and its average value is returned.

2) A value expression is not specified.

If a value expression is not specified, the measure is taken from the current context.

See Also

Count Sum Min Max Median Percentile WAvg

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.