Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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")
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 8 | |
| 6 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 10 | |
| 10 | |
| 8 | |
| 8 |