Forum Discussion
need help with Ranking in DAX
Below is my data Person Price Calls Measure - Price/Calls Tom 6319.85 102 61.95931373 Harry 3345.9 59 56.71016949 Gina 7678.55 137 56.04781022 George 10882.35 208 52...
Oh, I thought it was just a table and each person had one piece of data.
You may try the followings:
RANKX( ALLSELECTED( Table), CALCULATE( [Price divided by Calls], ALLEXCEPT( Table, Table[Person])), ,
DESC,
Dense)
Below is a snapshot of the data that i am working with and with your code for Rank i get below.
Not sure what am i missing here.
Oh, I thought it was just a table and each person had one piece of data.
You may try the followings:
RANKX( ALLSELECTED( Table),
CALCULATE( [Price divided by Calls], ALLEXCEPT( Table, Table[Person])),
,
DESC,
Dense)Thank you so much Anonymous ...that worked.