topic Re: Switch DAX to define YES=1, NO=0 to format font colour in DAX Commands and Tips

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

Anonymous — Wed, 06 Oct 2021 03:35:06 GMT

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!

VahidDM — Wed, 06 Oct 2021 03:47:58 GMT

Hi Anonymous

Try this:

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

Then use conditional formatting to change the 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!!

Anonymous — Wed, 06 Oct 2021 04:05:08 GMT

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