Rank order on sales percentage for each employee ID

[Gokul_G16]

Hi All,

Request you to need a help for rank order based on percentage value.

Data set like

ID.             %.          Rank order measure 

102221    95.10.        3

10223.       96.45.      2

102458     100.00.     1

102457.     100.00.    .1

Above data show like based on percentage rank order coulmn it was calculated.

But, request is those two same ID is reflected same rank .But on the time we need to see based on numeric value which ID .The final Rank should be in 1,2,3,4.. etc.

Kindly share Dax logic here.

Thanks

Gokul

[hita]

Hi

Seems unlikely as the % values are the same.

[Gokul_G16]

Hi  hita,

That's a problem how to fix the this scenario.

Thanks 

Gokul