Nested IF or ?

[Robin96]

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 measure called "Serviceavtaler", i also want the exact same for Subsription, but it only allows me to do 2 ifs in the return. Anyone have any idea?

[Greg_Deckler]

@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>
)

[Robin96]

Hey @Greg_Deckler 

I tried your solution, but it looks like the first condition is met in the first row, so it applies that expression to the whole table. i am trying something like this without any luck:

i want it to change color based on the value in the row level. Here is a picture of the measure for the table Is there any way to color format in here??:

[Greg_Deckler]

@Robin96 Right, the first condition that is met is what is returned. Note, that would be similar to nested IF statemetns. So, you will need additional conditions perhaps using && or something else to distinguish what things get what colors. Hard to say more as I don't know all the business rules.