Ranking Measure

[Arthur_NS]

Hi everyone,

I would like to show the ranking of a variable in a table.

Let me explain, from the below very simple dataset, I want to create a straight table.

The table would be linked to 3 slicers

- Market

- Day

- Session

Let's say we filter on 

Market => ES

Day => Mon

Session => ODR

The table would only be showing one line.

But I would like another column in the table that would give me the ranking of the Market and Session combinations (including all days).

So it's this instance, the ranking would be 4 (1% being the lowest number out of the 4 days).

Thank you!

[rubayatyasmin]

Hi, @Arthur_NS 

I didn't grasp the requirement fully, whatever I understood I tried to reproduce your problem and the result is,

Used this dax

[Arthur_NS]

Hello,

I'm trying your solution but it gives me this error message

[rubayatyasmin]

Are you trying to create a measure? As you can see from the ss I created a calculated column. So, you need to create a calculated column.