DAX calculate column - assets

[Anonymous]

Hello, 

I would like to calculate the column which will contain values like as COMPLIANT, NON-COMPLIANT and ERROR. If we have asset we need to show how is he: COMPLIANT, NON - COMPLIANT or ERROR. 

*Asset = server which has a specified number of settings

General rules:

1. The first one: NON - COMPLIANT: We have assets which have

• at least 1 settings compliant
• at least 1 settings non - compliant 
• at least 1 settings error 

Anything that has at least one non - compliant value = NON - COMPLIANT 

1. The second one: ERROR: We check if there are any assets with compliant and error values, if so = ERROR 

1. At the end: If we have vaule only for compliant = COMPLIANT 

Here is PBIX file: https://1drv.ms/u/s!AgEIVveTY4GymiLgMa04vFAHjw0C?e=NCZPQf 

Could you help me, please

[grantsamborn]

Maybe try this:

zColumn = 
    IF(
        [Non-Compliant] > 0,
        "Non-compliant",
        IF(
            [Error] > 0,
            "Error",
            "Compliant"
        )
    )