MEDIANX Function (DAX)

System_CAPS_ICON_note.jpg Note

This function is included in SQL Server 2016 Analysis Services (SSAS), Microsoft Power Pivot in Excel 2016 Preview editions, and Microsoft Power BI Designer Preview only. Information provided here is subject to change.

Returns the median number of an expression evaluated for each row in a table.

To return the median of numbers in a column, use MEDIAN Function (DAX).

MEDIANX(<table>, <expression>)  


tableThe table containing the rows for which the expression will be evaluated.
expressionThe expression to be evaluated for each row of the table.

A decimal number.

The MEDIANX function takes as its first argument a table, or an expression that returns a table. The second argument is a column that contains the numbers for which you want to compute the median, or an expression that evaluates to a column.

Only the numbers in the column are counted.

Logical values and text are ignored.

MEDIANX does not ignore blanks; however, MEDIAN does ignore blanks

The following computes the median age of customers who live in the USA.

=MEDIANX( FILTER(Customers, RELATED( Geography[Country]=”USA” ) ), Customers[Age] )  

MEDIAN Function (DAX)

Community Additions