Forum Discussion

Vijay08V's avatar
Vijay08V
Helper III
2 years ago

DAX for Ranking with duplicate values

Hi,

 

I have two tables and I am  trying to replicate a lookup function from an excel report. The first table (AB :AC)  has Weightage with rating. Rating is mapped using a lookup function from the second table (AE:AH) which has the Rating and Ranks. The problem here is since the ranks in second table are duplicated, I am not able to replicate the same function in Power BI.  The excel function for looking up the rating : =IF($AB7=0,"Doesnot",LOOKUP(RANK(AB7,$AB$7:$AB$1048576),$AH$2:$AH$5,$AE$2:$AE$5))

Any help on how to solve this issue ?

 

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    To disambiguate rankings you add small, inconsequential random numbers to each value to make them distinct.