Forum Discussion
Robin96
3 years agoHelper II
Nested IF or ?
Hey, i am running into a problem when i need to make a conditional formatting setting, but i have 15 measures for each row in a table. I have tried the measure below, but it only works for the measur...
Greg_Deckler
3 years agoCommunity Champion
Robin96 Try using a SWITCH(TRUE(),...) statement instead of nested IF statements.
SWITCH(TRUE(),
serviceavtaler <= 1, "#FF0000",
servicevtaler > 0, "#008000",
<next condition>, <next value>,
...,
<default value>
)