Solved: RANK with SWITCH

Anonymous · ‎09-23-2019

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

Mariusz · ‎09-23-2019

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.

Anonymous · ‎09-23-2019

Thanks for the solution!

Mariusz · ‎09-23-2019

@Anonymous no problem, happy to help!

Best Regards,
Mariusz

Please feel free to connect with me.

Mariusz · ‎09-23-2019

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.

RANK with SWITCH