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