MEDIAN DAX Function (Statistical)
Returns the 50th percentile of values in a column.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Column |
A column containing the values. |
Return values
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 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
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
Related functions
Other related functions are:
Last update: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Jes Hansen, Antti Komonen
Microsoft documentation: https://docs.microsoft.com/en-us/dax/median-function-dax