DAX Statistical - MEDIANX function



Description

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

Syntax

MEDIANX (<table>, <expression>)

Parameters

Sr.No. Parameter & Description
1

table

The table containing the rows for which the expression will be evaluated.

2

expression

The expression to be evaluated for each row of the table.

Return Value

A decimal number.

Remarks

  • The first parameter is a table, or an expression that returns a table.

  • The second parameter 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 considered.

Blanks, logical values, and text are ignored.

Example

= MEDIANX (Sales,Sales[Sales Amount]) 
dax_functions_statistical.htm
Advertisements