MEDIANX Function (DAX)



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>)
Parameters
Term  Definition 

table  The table containing the rows for which the expression will be evaluated. 
expression  The 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] )