RANK.EQ Function (DAX)

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 Blog Posts

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

Related Video Tutorials

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

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formula Reference Guide