Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RANK with SWITCH

Hi All,    I have the following SWITCH statement:    Difference = SWITCH( TRUE(), ISBLANK([Previous Wave]),0, ISBLANK([Current_Wave]),0, [Current_Wave] - [Previous Wave])   Would it be poss...
Tips and Tricks
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    there is no need to use the switch function, null ( blank ) is 0 and it will work fine when adding numbers and in Rank.

    Please see the below and the attached 

     

    Measure = 
RANKX( 
    ALLSELECTED( 'Table'[ID] ), 
    [Current Wave] - [Prewious Wave]
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

there is no need to use the switch function, null ( blank ) is 0 and it will work fine when adding numbers and in Rank.

Please see the below and the attached 

 

Measure = 
RANKX( 
    ALLSELECTED( 'Table'[ID] ), 
    [Current Wave] - [Prewious Wave]
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski