Forum Discussion

Dn_wemn's avatar
Dn_wemn
Helper II
2 years ago
Solved

Display column value by Rank = 1

Hi,   I'd like to create a column or a measure that displays the Sub-Segment value in which the created measure "Rank by Volume" equals 1. It should be displayed on a card visual. Expected result:...
Need Help
Show and Tell
Tips and Tricks
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi Dn_wemn 

     

    You can just simply apply the visual filter on card.

     

    Just take Sub-Segment value on the card . then open visual filter > add Rank column on visual filter section > put the condition show item when value is 1>apply filter 

     

     

     

    Every time when your ranking changes it auto changes. 

     

    No need to do anything extra.

     

    I hope I answered your question!

     

     

     

     

Dn_wemn's avatar
Dn_wemn
Helper II
2 years ago

Hi, I tried this before, but in this case Rank by Volume is a created measure. It does not allow me to filter Rank by volume = 1 in a card visual. I can't open the dropdown to select a filter option.

 

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi Dn_wemn 

Yes becasue measure wont work for you. You have to create calculated column for ranking then take ranking column into card filter.

 

 

  • Dn_wemn's avatar
    Dn_wemn
    Helper II
    2 years ago

    How would you create the calculated column for rank based on volume amount by Sub-segment in this case? 

    Edit: I got it myself.

    RANKX(

              FILTER( 'Table',
                    'Table'[Sub-segment] = EARLIER('Table'[Sub-segment])
              )
                , 'Table'[Volume]
                ,, DESC,Dense
                )

     

    Thanks.