topic Re: Nested IF or ? in DAX Commands and Tips

Nested IF or ?

Robin96 — Thu, 26 Jan 2023 13:05:34 GMT

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?

Re: Nested IF or ?

Greg_Deckler — Thu, 26 Jan 2023 13:11:36 GMT

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

Re: Nested IF or ?

Robin96 — Thu, 26 Jan 2023 13:20:06 GMT

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??:

Re: Nested IF or ?

Greg_Deckler — Thu, 26 Jan 2023 16:04:28 GMT

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.