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

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the solution!

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Anonymous no problem, happy to help!

    Best Regards,
    Mariusz

    Please feel free to connect with me.
    Mariusz Repczynski