DAX Measure Error

[Anonymous]

Hi Experts 

I am trying to exlcude the "Surgery completed", "Procedure completed"  from the measure below?

WHO - All Assessments Created = CALCULATE(COUNTROWS(Theatre_List_Cashup_Status_Monitoring), FILTER(Theatre_List_Cashup_Status_Monitoring, Theatre_List_Cashup_Status_Monitoring[WHO_Sign_In] = 0 && Theatre_List_Cashup_Status_Monitoring[WHO_Sign_Out] = 0 && Theatre_List_Cashup_Status_Monitoring[WHO_Time_Out] = 0 && Theatre_List_Cashup_Status_Monitoring[OperationOutcome] <> {"Surgery completed", "Procedure completed"}))

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

Please try this:-

WHO - All Assessments Created =
CALCULATE (
    COUNTROWS ( Theatre_List_Cashup_Status_Monitoring ),
    FILTER (
        Theatre_List_Cashup_Status_Monitoring,
        Theatre_List_Cashup_Status_Monitoring[WHO_Sign_In] = 0
            && Theatre_List_Cashup_Status_Monitoring[WHO_Sign_Out] = 0
            && Theatre_List_Cashup_Status_Monitoring[WHO_Time_Out] = 0
            && NOT ( Theatre_List_Cashup_Status_Monitoring[OperationOutcome] )
            IN { "Surgery completed", "Procedure completed" }
    )
)

Thanks,

Samarth