Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get 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")
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 9 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 17 | |
| 12 |