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