Dax formula + back ground color

[akerrout]

Hello everyone,

I would like to create a background color when :
if one of the two periods is blank and not the other, it should return in red where values are missing.
I have tried the following formula :

COP1 CHECK = IF(OR(AND([COP1]=BLANK(),NOT(ISBLANK([COP1 LMTD]))),AND([COP1 LMTD]=BLANK(), NOT(ISBLANK([COP1])))),"MISSING","OK")

then I used the formula as the background color criteria but it is not working .

i would like to have something similar or a third column that says that value are missing.Only if one of them are blanc , if both are blank it should not return anything.

[akerrout]

Thank you, @rubayatyasmin 

It works fine now!

[rubayatyasmin]

@akerrout good to know. 

appreciate the kudos. 

[rubayatyasmin · Accepted solution]

Hi, @akerrout 

try using || instead of AND

for example:

Missing Check =
IF (
(ISBLANK([COP1]) && NOT(ISBLANK([COP1 LMTD]))) ||
(NOT(ISBLANK([COP1])) && ISBLANK([COP1 LMTD])),
"MISSING",
BLANK()
)

This new column can be used to conditionally format your data visualization by setting the color to red when the "Missing Check" value is "MISSING". Please note that conditional formatting options depend on the visualization used, but in most cases you can use the "Field value" mode and select the "Missing Check" field.