# MEDIANDAX 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

Blanks are ignored. Only numeric data types are supported. Logical values, dates, and text columns are not supported.

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.
--  MEDIAN corresponds to PERCENTILE.INC with k=0.50
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
MEDIAN 4.5
MEDIANX 4.5
Average Sales 305.2084083507091
Median Sales 114.21
```--  MEDIAN differs from MEDIANX when there are BLANK values involved
DEFINE
TABLE SampleData = { BLANK(), 2, 4, 4, 4, 5, 5, 7, 9 }
EVALUATE
{
( "AVERAGE",  AVERAGE ( SampleData[Value] ) ),
( "MEDIAN",   MEDIAN ( SampleData[Value] ) ),
( "MEDIANX",  MEDIANX ( SampleData, SampleData[Value] ) )
}
```
Value1 Value2
AVERAGE 5
MEDIAN 4.5
MEDIANX 4

## Related 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

## Related functions

Other related functions are:

Last update: Jul 12, 2024     » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Jes Hansen, Antti Komonen

Microsoft documentation: https://docs.microsoft.com/en-us/dax/median-function-dax

# Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

# Row Context

This expression is executed in a Row Context. Click to read more.

# Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

# Not recommended

The use of this parameter is not recommended.

# Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

# Volatile

A volatile function may return a different result every time you call it, even if you provide the same arguments. Click to read more.

# Deprecated

This parameter is deprecated and its use is not recommended.

# DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

### Contribute

Want to improve the content of MEDIAN? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.