Returns the 50th percentile of values in a column.
A column containing the values.
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:
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
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/median-function-dax