Forum Discussion
Solved
Create one filter to get two rank
Hi community, I am creating a comparison dashboard for two state, following this link (https://www.youtube.com/watch?v=vzI9T3Wdpak&t=300s). The dashboard uses MAX and MIN values to filter two va...
kobkabnaja This is how should address this, use Rank 1 and Rank 2 in the visual, Tweak the solution as you see fit.
Rank Measure = RANKX ( ALL ( 'migration'[Name] ), CALCULATE ( SUM ( 'migration'[NETFLOW_TOT] ) ), , DESC ) Rank 1 = VAR __Max = MAX ( 'migration'[Name] ) RETURN CALCULATE ( [Rank Measure], 'migration'[Name] = __Max ) Rank 2 = VAR __Min= MIN( 'migration'[Name] ) RETURN CALCULATE ( [Rank Measure], 'migration'[Name] = __Min )
parry2k
Super User
Super Userkobkabnaja This is how should address this, use Rank 1 and Rank 2 in the visual, Tweak the solution as you see fit.
Rank Measure =
RANKX (
ALL ( 'migration'[Name] ),
CALCULATE ( SUM ( 'migration'[NETFLOW_TOT] ) ),
,
DESC
)
Rank 1 =
VAR __Max = MAX ( 'migration'[Name] )
RETURN
CALCULATE (
[Rank Measure],
'migration'[Name] = __Max
)
Rank 2 =
VAR __Min= MIN( 'migration'[Name] )
RETURN
CALCULATE (
[Rank Measure],
'migration'[Name] = __Min
)
parry2k Thank you so much. This works like a charm!!!