Forum Discussion
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: 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 |
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!
7 Replies
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
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!
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.
