RANKX HELP

Question

Hi There,I'm having trouble with my RankX function and have tried following tutorials and tips and am not getting the same resultI have a list of names and these names are associated to a number of transactionsI am trying to create a ranking that ranks on the number of transactions against each nameRankingTrans = RANKX(ALL('CCData'[Sales Rep]), [TransCount])This ranks the data which is fine but the ranking is skipping numbers e.g 1,2,3,4,4,5,5,5,9,10,10,12&nbsp;How can I stop this from happening?

anonymous · Answer

Hi&nbsp;LDC20&nbsp;,&nbsp;This is because Sales Rep ranked 4 will have same transaction counts. Same would be rank 5,9,10.&nbsp;&nbsp;What is the end output needed.&nbsp;kindly share sample data.&nbsp;Regards,Harsh Nathani

ldc20 · Answer

Thanks for the reply&nbsp;In my rankings I dont want it to skip any numbers

lbendlin · Answer

Create an index column over your numbers instead of using RANKX, or use the DENSE ties option if you insist on using RANKX&nbsp;https://docs.microsoft.com/en-us/dax/rankx-function-dax#syntax

anonymous · Answer

Hi&nbsp;LDC20&nbsp;,&nbsp;&nbsp;Create a measure&nbsp;Randome = RAND()&nbsp;&nbsp;Then add this measure to your ranking measure&nbsp;RankingTrans = RANKX(ALL('CCData'[Sales Rep]), [TransCount] + [RAND])&nbsp;You will get rank as 1, 2 ,3 ,4.2,4.5 ... etc&nbsp;else do you have any other supporting column like date,.&nbsp;Then follow this articles&nbsp;https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measureshttps://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columnshttps://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale&nbsp;&nbsp;else pls follow this solved solution&nbsp;&nbsp;https://community.powerbi.com/t5/DAX-Commands-and-Tips/Can-t-break-RANK-TIES-cannot-use-RAND/td-p/1032338&nbsp;&nbsp;Regards,Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)&nbsp;

ldc20 · Answer

I added in the DENSE and its still ranking similar values as the sameSee attached screenshot

Forum Discussion

RANKX HELP

5 Replies

Related content

RankX

RANKX

Advanced Ranking (Rankx)

Rank vs Rankx

RankX