Ranking with filters on selective columns

[Manne_DE]

Hi,

I am lookings for a Dax Measure statement to Rank the follwing table :

Customer

Country

Year

Total Sales

The ranking should filter on country, but use the Total Sales over all years.

e.g. Customer 1 has a in Year 1 a Total Sales which would rank him at position 5, but over all years a position 1. The result of the Dax statement should return the ranking of 1. If it is been filtered by a particular country, the ranking will be for this country only, but again for all years.

Any idea of the correct RANKX statement for this ?

Thank You,

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

[Manne_DE · Accepted solution]

Great - yes, this was what I had been looking for - Thank You

Also great, that you did an example file - this helps greatly to understand the solution quickly