Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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!
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.
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.
How would you create the calculated column for rank based on volume amount by Sub-segment in this case?
Edit: I got it myself.
Thanks.
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, it does not show SUV when I tried it:
btw, here is my measure for rank by volume:
Hi @Dn_wemn
You can try my solution without creating measure.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |