Forum Discussion

kobkabnaja's avatar
kobkabnaja
Icon for Helper II rankHelper II
1 year ago
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...
Need Help
  • parry2k's avatar
    parry2k
    1 year ago

    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
)