Fixed ranking of percentage measure

[Anonymous]

Hi all,

I have a table of data like this:

I need to be able to show results by client & country, filtering by Year & Version, which then shows the GP % of Revenue (already created as a measure called GP %) ranked against all other client country combinations for the chosen Year & Version. So the output would look something like this:

Does anyone have any ideas? Thanks for looking!

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may create rank using Column or measure like DAX below.

Column1= RANKX(FILTER(ALLSELECTED(Table1),Table1[Country]=EARLIER(Table1[Country])&&Table1[Year & Version]=EARLIER(Table1[Year & Version])),Table1[GP],,DESC, Skip)
 
Measure1= RANKX(FILTER(ALLSELECTED(Table1),Table1[Country]=MAX(Table1[Country])&&Table1[Year & Version]=MAX(Table1[Year & Version])),MAX(Table1[GP]),,DESC, Skip)

You can go through the link https://docs.microsoft.com/zh-cn/dax/rankx-function-dax to learn more about the RANKX .

Best Regards,

Amy

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

[parry2k]

@Anonymous I believe this post expalains Rank in detail and will get you going.