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
Attached please find the .pbix file. I have two measures, [x1] and [x2]. I currently have the following DAX expression:
Colour =
IF ( [x1] > 3, "Red", "Green" )
I'd like to be able to also include the measure [x2] in the above expression without creating a sepeate measure. Is this possible?.
@HamidBee Maybe:
Colour =
SWITCH(TRUE(),
[x1] > 3, "Red",
[x2] < 45, "Red",
"Green"
)
@HamidBee Switch your x2 and x1 lines.
This is what I get:
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!