SWITCH Condition not working for multiples conditions!

[manuelfigueira]

Hello Everyone!

I'm trying to apply a condition using SWITCH(TRUE() and the last condition is not working at all. When the item age is >181 still is showing HOLD rather then RELEASE and I can't get throug to make the condition show me RELEASE for those > 181, is there something I'm missing on this?

Many thanks!!

Manuel

Measure = SWITCH(TRUE(),
'Table1'[Condition] = "Ace", "Fly",
RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] < 91, "HOLD",
RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] > 90, "HOLD",
RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] < 180, "HOLD",
RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] > 181, "RELEASE",
"RELEASE"
)

[az38 · Accepted solution]

Hi @manuelfigueira 

it is correct, because 181 still more then 90, as i sure.

try

Measure = SWITCH(TRUE(),
'Table1'[Condition] = "Ace", "Fly",
RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] < 90, "HOLD",
RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] >= 90, "HOLD"&& 'Table2'[Age] <= 180, "HOLD",
RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] >= 181, "RELEASE",
"RELEASE"
)

and pay attention to values 90 and 180

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[manuelfigueira]

Hello @az38 ! Thank you for the solution! Rally helped me! 

[amitchandak]

Correct

RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] > 90, "HOLD"

it covers everything >90

Try one of the two

Measure = SWITCH(TRUE(),
'Table1'[Condition] = "Ace", "Fly",
RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] < 91, "HOLD",
RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] > 90 && 'Table2'[Age] < 180, "HOLD",
RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] > 181, "RELEASE",
"RELEASE"
)


Measure = SWITCH(TRUE(),
'Table1'[Condition] = "Ace", "Fly",
RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] < 180, "HOLD",
RELATED('Pivot'[Status]) = "Unmatched Standard" && 'Table2'[Age] > 181, "RELEASE",
"RELEASE"
)