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 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.

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, Jes Hansen