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

RANK.EQ ( <Value>, <ColumnName> [, <Order>] )

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

Scalar A single integer value.

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:

RANKX

Last update: Dec 7, 2019 » Contribute » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber

MSDN documentation: https://docs.microsoft.com/en-us/dax/rank-eq-function-dax