MEDIAN

This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here.

This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here.

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:

WITH MEMBER [Measures].[Median Sales] AS
Median([Product].[Product].Members, [Measures].[Internet Sales Amount])
SELECT 
[Measures].[Median Sales] ON COLUMNS
FROM [AdventureWorksMF_ValueBased]