RANK with SWITCH

[Anonymous]

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 possible to rank the results of this SWITCH statement? 

Thanks,

Tom

[Anonymous]

Thanks for the solution!

[Mariusz]

@Anonymous no problem, happy to help!

Best Regards,
Mariusz

Please feel free to connect with me.

[Mariusz · Accepted solution]

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.