Forum Discussion

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 ...

Anonymous

Not applicable

6 years ago

Hi LDC20 ,

This is because Sales Rep ranked 4 will have same transaction counts. Same would be rank 5,9,10.

What is the end output needed.

kindly share sample data.

Regards,

Harsh Nathani

Frequent Visitor

6 years ago

Thanks for the reply

In my rankings I dont want it to skip any numbers

lbendlin
Super User
6 years ago
Create an index column over your numbers instead of using RANKX, or use the DENSE ties option if you insist on using RANKX

https://docs.microsoft.com/en-us/dax/rankx-function-dax#syntax
- LDC20
  Frequent Visitor
  6 years ago
  I added in the DENSE and its still ranking similar values as the same
  See attached screenshot
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)

Related content