Forum Discussion
Rank by percentage
Hi folks,
I want to have top n ranked customers based on their tat percentage but the issue is that I am getting the same rank for similar percentage value.
I want to have different rank for all the customers so if I choose top 10 on my slicer it should only show top 10 customers with 100% instead of showing them all as rank 1.
Can anyone solve this issue.
2 Replies
Hi sathish_kumar1 ,
Looks like you're almost there.
Once you create a measure to get the correct rank, add this measure to visual filter and set value <= 10.
Then the visual should only show top 10 value.
If you have difficult to get the correct rank, please show some sample data so that we could help to create dax formula.
Best Regards,
Jay
