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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello,
I have a Measure configured like this, which is to return back a background color for the following conditions:
IF Scheduled Qty> 0 and Scheduled Qty= Completed Quantity then green
If Scheduled Qty> 0 and Completed Qty >0 and Completed Quantity < Scheduled Quantity, Dark Blue,
White.
Solved! Go to Solution.
Try using && instead of & . Also, you should pre-calculate your MAXX expression as variables first, so that you don't recalculate them multiple times and hurt performance.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Try returning your first two variables instead of the last one to troubleshoot. Those are returning a Max value while the visual is likely showing the sum of that column. If you replace MAXX with SUMX, it work as expected.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Try using && instead of & . Also, you should pre-calculate your MAXX expression as variables first, so that you don't recalculate them multiple times and hurt performance.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
This seems to work:
The issue I have though, is it does not rollup with the matrix: for example the 9 and the six values should be dark blue, not green, per this code:
This is a better picture... to demonstrate... the issue, and the travel and setup item should be dark blue as well.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.