topic DAX Command To Mark Compliant/Non Compliant in DAX Commands and Tips

DAX Command To Mark Compliant/Non Compliant

sjacob — Fri, 24 Jun 2022 14:28:39 GMT

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

Re: DAX Command To Mark Compliant/Non Compliant

latimeria — Fri, 24 Jun 2022 15:46:02 GMT

Add a new column with this Dax code

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

Re: DAX Command To Mark Compliant/Non Compliant

sjacob — Fri, 24 Jun 2022 15:55:15 GMT

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

Regards,

Sajan