Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 of transactions
I am trying to create a ranking that ranks on the number of transactions against each name
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
Thanks for the reply
In my rankings I dont want it to skip any numbers
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
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
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
I added in the DENSE and its still ranking similar values as the same
See attached screenshot
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |