DAX Command To Mark Compliant/Non Compliant

[sjacob]

Hello,

I would like assistance in creating a DAX formula that can mark values from a column as compliant or non-compliant.

For example, if I have the following columns and values, I would like to add a second column, that can mark which values are compliant and non compliant:

Gender      DAX Measure Column:

Male          Compliant

F                Non-Compliant

Female      Compliant

F                Non-Compliant

(blank)       Non-Compliant

Appreciate the assistance.

Regards,

Sajan

[sjacob]

Thank you very much! This definitely helps. I'm new to DAX so appreciate the assistance.

Regards,

Sajan

[latimeria · Accepted solution]

Add a new column with this Dax code

Compliant = IF ( 'Table'[Column1] in { "Male", "Female" } , "Compliant" , "Non-Compliant" )