Here’s some logic that gets you the results in a calculated table (remember user would need to refresh the report everytime to get this updated)
Use similar logic to me just add your measures.
First create the first 3 columns
Then use the logic within a calculated column
At the moment I can’t think of any other way to do this dynamically in measures as you need to create the index column in some way.
I use the RANKX function to get the index column based on the ranking.
This works well two as this is somewhat dynamic, say new products came online etc, it would always summarize the entire result.
Let me know if this works.