Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@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 , try like
Switch( True(),
D>0 and [S]>0 and [T] >0, "Blue" ,
[D] >0 and [S] >0 , "green",
[D] >0, "yellow",
"Red")
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |