Forum Discussion

Ruedi007's avatar
Ruedi007
Frequent Visitor
6 years ago
Solved

Auto rank rows durning slicing

Hi! I have a table where I have three columns ordered by Inhabitants   1. State 2. City 3. Inhabitants   What I need is a column Rank that just starts with 1 and ends with the number of the la...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Ruedi007 ,

     

    Please create two measures like this.

    Current_Inhabitants = MAX(Sheet1[Inhabitants])
    _Rank = 
RANKX(
    ALLSELECTED(Sheet1),
    [Current_Inhabitants],
    , DESC, Dense
)

     

    Best regards,
    Lionel Chen

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

     

Ruedi007's avatar
Ruedi007
Frequent Visitor
6 years ago

Hello thank you for your answer. Unfortunately non of the linked solutions cover my problem. I will explain it with shown data that is a good idea.

 

The data and slicer look like this:

Data and Slicer

 

The result without selecting a slicer should look like this:

No Selection

If I select one of the options in the slicer the list should change to:

With selection (California)

In this case I selected california.

 

As you see the Rank column adjusts depending on the Slicer. I want to have this feature in the Report and Dashboard. If anyone has an idea how to accomplish this? That would be very helpful for me.

 

Best!

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Ruedi007 ,

 

Please create two measures like this.

Current_Inhabitants = MAX(Sheet1[Inhabitants])
_Rank = 
RANKX(
    ALLSELECTED(Sheet1),
    [Current_Inhabitants],
    , DESC, Dense
)

 

Best regards,
Lionel Chen

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