Need to modify dax measure to show red if the number is negative.

[PBI-Curious]

Power BI Community Good Day!

I am using the following measure in my dashboard as a label.

The number is negative. How can I modify the dax measure below to show red if the number is negative? 

Amount Lost = CALCULATE(SUM(metricsrevenuecustomer[amount]),metricsrevenuecustomer[revenue_type_lvl2] ="Lost")

Much appreciate your time.

Thank you

[v-zhangti · Accepted solution]

Hi, @PBI-Curious 

Conditionally formatted measures need to be written separately.

Color measure = IF([Amount Lost]<0,"Red")

This is the Card view.

This is the Table view.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vicky_]

You can use conditional formatting on the visual - see this guide for how to do that: https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...