Forum Discussion
Ranking not working correctly in map
Hi Anonymous
I change your Rank measure and achieve your goal.
New Rank Measure:
Rank = RANKX(ALL('Sales Staff'),CALCULATE(SUM(Sales[Sale])),,DESC,Dense)Result:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Could you share your pbix file with me by your OneDrive for Business again? I can't get access to it. Or if you have solved your problem, kindly share your workaround and mark it as a solution. More people will benefit from it.
Best Regards,
Rico Zhou
AnonymousThanks for your help. I have updated the link to the file.
Hi Anonymous
I change your Rank measure and achieve your goal.
New Rank Measure:
Rank = RANKX(ALL('Sales Staff'),CALCULATE(SUM(Sales[Sale])),,DESC,Dense)Result:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
Please share your pbix file from your OneDrive for Business. Due to I don't have a permission to the pbix file you have shared with me.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous Unfortunatly, my employer has disabled the link sharing with people outside of the organization. You should be able to download the link by pressing the download button on the top right:
Works perfectly, thanks so much Anonymous!