Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
I am trying to exlcude the "Surgery completed", "Procedure completed" from the measure below?
Solved! Go to 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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |