MEDIAN DAX Function (Statistical)

Returns the 50th percentile of values in a column.

Syntax

MEDIAN ( <Column> )

Parameter	Attributes	Description
Column		A column containing the values.

Return values

Scalar A single variant value.

Median value

Remarks

Only numeric values in the column are counted. Blanks, logical values, and text are ignored.

If there are no blanks, logical values, or text values, then the following MEDIAN call:

MEDIAN ( table[column] )

corresponds to the following MEDIANX call:

MEDIANX (
    table,
    table[column] 
)

The result is blank in case there are no rows in the table with a non-blank value.

» 1 related article
» 1 related function

Examples

--  MEDIAN is the compact version of MEDIANX
--  MEDIANX returns the 50th percentile of an expression
--  evaluated row-by-row on a table.
DEFINE
    TABLE SampleData = { 2, 4, 4, 4, 5, 5, 7, 9 }
EVALUATE
{
     ( "AVERAGE",  AVERAGE ( SampleData[Value] ) ),
     ( "MEDIAN",   MEDIAN ( SampleData[Value] ) ),
     ( "MEDIANX",  MEDIANX ( SampleData, SampleData[Value] ) ),
     ( "Average Sales", AVERAGEX ( Sales, Sales[Quantity] * Sales[Net Price] ) ),
     ( "Median Sales", MEDIANX ( Sales, Sales[Quantity] * Sales[Net Price] ) )
}

Value1	Value2
AVERAGE	5.00
MEDIAN	4.50
MEDIANX	4.50
Average Sales	305.21
Median Sales	114.21

Learn more about MEDIAN in the following articles:

Statistical Patterns
DAX includes a few statistical aggregation functions, such as average, variance, and standard deviation. Other typical statistical calculations require you to write longer DAX expressions. Excel, from this point of view, has a much richer language. The Statistical Patterns are a collection of common statistical calculations: median, mode, moving average, percentile, and quartile. » Read more