Switch F-on Problem

[Boja]

Hello,

Could somebody please have a look at the switch measure and tell me why it is not working? it should show upper arrow.

Key = SWITCH( TRUE(),
[ver1 fb]<[ver2 fb], UNICHAR(9660),
[ver1 fb]>[ver2 fb], UNICHAR(9650),
UNICHAR(9644)
)

  

[Boja · Accepted solution]

Strange, but the IF f-on works well in this case. Luckely, there is no need for more nested IFs 🙂

Key2 = 
IF(
[ver1 fb]<[ver2 fb], UNICHAR(9660),
IF( [ver1 fb]>[ver2 fb], UNICHAR(9650),UNICHAR(9644))
)

[Greg_Deckler]

OK, that's the second one today that I can't recreate. I tried by entering in your data and then adding a calculated column. I used a calculated column because there is no aggregation that would indicate that it is a measure. I get up arrows. I'm on the March 2018 edition.

[Boja]

Hi Greg,

Actually there is aggreagation. Both var1 fb and var2 fb are counts of responses by different criteria. 

I am also working on the March edition, but will try to reinstall anyway.

do you maybe have another suggestion? thank you for support though 🙂

[Greg_Deckler]

OK, so "var1 fb" and "var2 fb" are measures then. I'll try to recreate it with measures.