Forum Discussion

LDC20's avatar
LDC20
Frequent Visitor
6 years ago

RANKX HELP

Hi There, I'm having trouble with my RankX function and have tried following tutorials and tips and am not getting the same result I have a list of names and these names are associated to a number ...
LDC20's avatar
LDC20
Frequent Visitor
6 years ago

Thanks for the reply

 

In my rankings I dont want it to skip any numbers

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi LDC20 ,

 

 

Create a measure

 

Randome = RAND()

 

 

Then add this measure to your ranking measure

 

RankingTrans = RANKX(ALL('CCData'[Sales Rep]), [TransCount] + [RAND])

 

You will get rank as 1, 2 ,3 ,4.2,4.5 ... etc

 

else do you have any other supporting column like date,.

 

Then follow this articles

 

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

 

 

else pls follow this solved solution 

 

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Can-t-break-RANK-TIES-cannot-use-RAND/td-p/1032338

 

 

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)