DAX Function Guide

Sam McKay

CEO & Founder

The RANK.EQ function (DAX) returns the ranking of a number in a list of numbers.

RANK.EQ(
<value>, <columnName>[, <order>]
)

This function will rank a number against a list of other numeric values. It is not necessary to sort the values in the list before using RANK.EQ.

columnName cannot refer to any column created using these functions: ADDCOLUMNS, ROW or SUMMARIZE.I
If value is not in columnName or value is a blank, then RANK.EQ returns a blank value.
Duplicate values of value receive the same rank value; the next rank value assigned will be the rank value plus the number of duplicate values. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 16 (11 + 5).

=RANK.EQ(InternetSales_USD[SalesAmount_USD], InternetSales_USD[SalesAmount_USD])

=RANK.EQ(Students[Test_Score], NationalScores[Test_Score])

=RANK.EQ(1,A1:A5,1)