DAX if formula with multiple conditions

[Rody]

Hi there,

I have searched the forum and tried multiple suggestions but I have not managed to work it out. What I like to do is add a new column, that shows a 1 if the condition is met otherwise 0. I am using the formula below but shows all items as 0. If I filter manually on the columns than  multiple records show up. Does anyone has an idea how to do this better? Thanks in advance.

Lagging - Survey items overdue = IF(

    'Cority_Corrective_Actions_M_001 SiC'[Reference Type] = "Safety Inspection/Survey"

    && 'Cority_Corrective_Actions_M_001 SiC'[Status] = "Action - In Progress"

    && 'Cority_Corrective_Actions_M_001 SiC'[Status] = "Action - Ready for Review"

    && 'Cority_Corrective_Actions_M_001 SiC'[Observation Status] = "Overdue",

    1,

    0

)

[MahyarTF]

Hi,

As you used "&&"in your Dax for the Status column in 2 different values, the result of the If function should go to Else (0).

If you want to check if the Status is "Action - In Progress" or "Action - Ready for Review", you need to put "||" or OR() in your dax formula

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please try the below.

I think, the reason why the result only shows zero is because of the column, 'Cority_Corrective_Actions_M_001 SiC'[Status] = "Action - In Progress" and "Action - Ready for Review"

I am not sure, but I think the [Status] column in one row cannot have two result at the same time.

Lagging - Survey items overdue =
IF (
    'Cority_Corrective_Actions_M_001 SiC'[Reference Type] = "Safety Inspection/Survey"
        && OR (
            'Cority_Corrective_Actions_M_001 SiC'[Status] = "Action - In Progress",
            'Cority_Corrective_Actions_M_001 SiC'[Status] = "Action - Ready for Review"
        )
        && 'Cority_Corrective_Actions_M_001 SiC'[Observation Status] = "Overdue",
    1,
    0
)

[Rody]

Amazing, that sorted it! I get your point now about two variables in the same column. Thanks heaps, that took me all morning.