MEDIANX
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
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.
Syntax
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. |
Return value
A decimal number.
Remarks
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
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
The following computes the median age of customers who live in the USA.
= MEDIANX( FILTER(Customers, RELATED( Geography[Country]="USA" ) ), Customers[Age] )
Related content
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho