RANK.EQ DAX Function (Statistical)
Returns the rank of a number in a column of numbers. If more than one value has the same rank, the top rank of that set of values is returned.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Value |
The value to be ranked. |
|
| ColumnName |
A column in which the value will be ranked. |
|
| Order | Optional |
The order to be applied. 0/FALSE/DESC – descending; 1/TRUE/ASC – ascending. If omitted, the default is descending. |
Return values
A number indicating the rank of Value among the numbers in ColumnName.
Remarks
The following RANK.EQ calls:
RANK.EQ ( <value>, table[column] ) RANK.EQ ( <value>, table[column], <order> )
correspond to the following RANKX calls:
RANKX (
VALUES ( table[column] ),
table[column],
<value>
)
RANKX (
VALUES ( table[column] ),
table[column],
<value>,
<order>
)
The <value> placeholder is a DAX expression executed in the filter context where RANK.EQ is evaluated.
The <order> placeholder is the optional order argument, which is descending by default.
Related functions
Other related functions are:
Last update: Mar 20, 2020 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
MSDN documentation: https://docs.microsoft.com/en-us/dax/rank-eq-function-dax