Forum Discussion

Arthur_NS's avatar
Arthur_NS
Helper I
3 years ago

Ranking Measure

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!

 

Need Help

3 Replies

  • rubayatyasmin's avatar
    rubayatyasmin
    Community Champion
    3 years ago

    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's avatar
      Arthur_NS
      Helper I
      3 years ago

      Hello,

       

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

       

      • rubayatyasmin's avatar
        rubayatyasmin
        Community Champion
        3 years ago

        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.