MEDIAN

MEDIAN is a DAX function that returns the 50th percentile of values in a column.

Syntax

MEDIAN( Column )

Argument	Properties	Description
Column		A column containing the values.

Return Values

A decimal number.

Remarks

• Only the numbers in the column are counted. Blanks are ignored. Logical values, dates, and text are not supported.

• MEDIAN( Table[Column] ) is equivalent to MEDIANX( Table, Table[Column] ).

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

The following computes the median of a column named Age in a table named Customers:

= MEDIAN( Customers[Age] )

Related functions

Other functions related to MEDIAN are:

• MEDIANX

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/dax/median-function-dax