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.

Scalar A single variant value.

Median value

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

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.

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

Other related functions are:

Contributors: Alberto Ferrari, Marco Russo