## How does the RANK.EQ function (DAX) work?

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

## RANK.EQ Formula Syntax

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

## How do you use the RANK.EQ function?

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.

## Related Support Forum Posts

Dax Calculation question
Dax not working
DAX Buffer Calculation Query

## Considerations when using the RANK.EQ function

• 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).

## Formula examples using the RANK.EQ function

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

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

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

## Related Course Modules 