DAX for Ranking with duplicate values

[Vijay08V]

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 ?

[lbendlin]

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