topic Several conditions if with color in DAX Commands and Tips

Several conditions if with color

Anonymous — Thu, 07 Apr 2022 12:32:50 GMT

Hi, I would like to create a dax measure with multiples conditions with different measures.

My goal is to create an if-else and return the last True condition

for example

IF( [D] >0, then "yellow",else: "red")

IF ([D] >0 and [S] >0 , then "green")

IF(D>0 and [S]>0 and [T] >0, then "Blue")

If only the first condition is respected return "yellow"

If the first and the second conditions are respected so it returns "green"

If the third one is respected return "blue"

Thank you for helping

amitchandak — Thu, 07 Apr 2022 13:19:45 GMT

Anonymous , try like

Switch( True(),
D>0 and [S]>0 and [T] >0, "Blue" ,
[D] >0 and [S] >0 , "green",
[D] >0, "yellow",
"Red")

Anonymous — Thu, 07 Apr 2022 13:50:35 GMT

Thank you so much amitchandak it works ! 😄