Forum Discussion

mgaut341's avatar
mgaut341
Icon for Helper II rankHelper II
2 years ago

PowerBi Measure for Appointment types

I am trying to create a measure looking at the no show rate for appointment types. For my numerator I have the number of no shows appointments that were documented. I think I need to add the appoint...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

mgaut341 , Try like

 

CALCULATE(DISTINCTCOUNT('New Appointment_Fact'[prnt apptid]), filter('New Appointment_Fact', 'New Appointment_Fact'[appttype] in {"Vaccine",,"Same Day Vaccine"} && 'New Appointment_Fact'[apptslotstatus] in {"4 - Charge Entered", "f - Filled", "2 - Checked In", "3 - Checked Out" , "x - Cancelled"})) + CALCULATE(DISTINCTCOUNT('New Appointment_Fact'[apptid]), filter('New Appointment_Fact','New Appointment_Fact'[apptslotstatus] = "o - Open Slot"))