fbpx

Median (MDX)

Returns the median value of the specified set expression.

Parameters

Name Type Cardinality Default value
  set-expression  one   
  value-expression  zero-one   

Return

value

Description

The median function calculates the median value of the non-empty cells.

1) A value expression is specified.

When the value expression is specified, the measure is evaluated over the set and its median 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.

How is the median value calculated ?

After sorting the set, the median value depends on the number of items :

a) if it's an odd number : returns the value of the member in the middle of the set.

b) if it's an even number : returns the average value of the two member in the middle of the set.

See Also

Percentile Avg Min Max Sum Vector

Examples

Special Examples (errors, null, ...)

XMLA Properties

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