Show Rank in Card visual

Hi Sri_phani 

Would you need rank by Resolve attainment? And does the ranking need to change based on the value chosen by slicer?

This is my current test to rank by Resolve attainment.

Measure:

Resolve = DIVIDE(MAX([Resolve Numerator]), MAX([Resolve Denominator]))

Resolve attainment = [Resolve] / 0.6

rank = RANKX(ALL(Sheet1), [Resolve attainment], , ASC, Dense)

Then select Multi-row card visualization.

Output:

If this is not what you are looking for, then please explain your requirements in more detail, or you can present your desired results in Excel based on the sample data. Please remove any sensitive data in advance.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.