Display column value by Rank = 1

[Dn_wemn]

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: So here the card should display "SUV" because it has rank = 1 which is based on highest volume for each Sub-Segment.

Sample data:

Sub-Segment	Rank by Volume (Measure)	Sum of Volume
SUV	1	200
Car	2	150
Van	3	120
PUP	4	100
MPV	5	90

[Uzi2019 · Accepted solution]

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]

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]

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]

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.

[barritown]

Hi @Dn_wemn,

You can try something like this:

In plain text for convenience:

Sub-Segment no 1 = 
VAR _tbl = ADDCOLUMNS ( 'Table', "@Rank", [Rank_measure] )
RETURN MAXX ( FILTER ( _tbl, [@Rank] = 1 ), [Sub-Segment] )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

[Dn_wemn]

Hi, it does not show SUV when I tried it: 

btw, here is my measure for rank by volume:

Rank by Volume = RANKX(

           ALLSELECTED( 'Table'[Sub-Segment])

            , CALCULATE(SUM('Table'[Volume])) 

            )

[Uzi2019]

Hi @Dn_wemn 
You can try my solution without creating measure.