MEDIAN

Description:

This function is used to return a scalar value signifying the median of the given set.

Syntax:

Median(Set_Expression, Measure, Inclusive/Exclusive flag)

Return Type:

SCALAR

Parameters:

Parameter	Description

Parameter	Description
Set_Expression	It is a valid MDX expression that returns a set.
Measure	It is a valid measure.
Inclusive/Exclusive flag	It is a flag specifying Inclusive or Exclusive implementation of percentile. The valid values are Inclusive / Exclusive. Inclusive: Specifies the value at or below which the given percentage of values may be found in distribution. Exclusive: Specifies the value below which the given percentage of values may be found in distribution.

Example:

Median([Geo].[H_Geo].[Country], [Measures].[Sum Sales], Exclusive)