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!

     

     

     

     

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.