Switch DAX to define YES=1, NO=0 to format font colour

[Anonymous]

HI

This is seemingly simple, not sure why i just cant get the syntax right, any help appreciated!

I just want to match YES to 1, and NO to 0, then apply the measure to format my YES to red. 

the table is filtered by a slicer. 

Thanks!

[Anonymous]

Thank you so much!! baffles me why the simplest codes are the hardest to write 😅

[VahidDM · Accepted solution]

Hi @Anonymous 

Try this:

TrimYESNO=
If(max(SVClist[TRIM])="YES",1,0)

Then use conditional formatting to change the font color.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#format-background-or-font-color

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

Appreciate your Kudos!!