This KPI Hub has moved to one shared hub for Excel and Power BI. Open the new KPI Hub →
Hospital & Clinic KPIs in Power BI
Ten important KPIs for a hospital or clinic. Each card has what it is, why it matters, the DAX measure and a tiny worked example. Tap a card to open it full size, or scan its QR code.
About this data: All examples are made-up teaching numbers for hospitals and clinics in Nagpur, Birmingham, Kolkata, Houston, Pune, Munich, Glasgow, Delhi, Lucknow and Sydney, in ₹ and €. No real patient data is used. Table names (Stays, Visits, Bills, Costs, Appts, Claims, Survey, Ward) are sample names.
Occupancy % = DIVIDE(SUM(Stays[BedDays]), MAX(Ward[Beds]) * COUNTROWS('Date'))
ALOS = DIVIDE(SUM(Stays[LOSDays]), COUNTROWS(Stays))
Avg Wait = AVERAGEX(Visits, DATEDIFF(Visits[CheckIn], Visits[SeenAt], MINUTE))
Readmit % = DIVIDE(CALCULATE(COUNTROWS(Stays), Stays[DaysSinceLast] <= 30), COUNTROWS(Stays))
Revenue per Patient = DIVIDE(SUM(Bills[Amount]), DISTINCTCOUNT(Bills[PatientID]))
Cost per Patient Day = DIVIDE(SUM(Costs[Amount]), SUM(Stays[BedDays]))
No-Show % = DIVIDE(CALCULATE(COUNTROWS(Appts), Appts[Status] = "No-show"), COUNTROWS(Appts))
Denial % = DIVIDE(CALCULATE(COUNTROWS(Claims), Claims[Status] = "Denied"), COUNTROWS(Claims))
Patients per Doctor Day = DIVIDE(COUNTROWS(Visits), DISTINCTCOUNT(Visits[DoctorID]) * DISTINCTCOUNT(Visits[VisitDate]))
NPS = DIVIDE(COUNTROWS(FILTER(Survey,Survey[Score]>=9)) - COUNTROWS(FILTER(Survey,Survey[Score]<=6)), COUNTROWS(Survey)) * 100Quick quiz
1. 50 beds, 10 days, 400 bed-days used. Occupancy % is…
2. 900 inpatient days, 300 discharges. ALOS is…
3. 200 survey replies: 120 promoters, 30 detractors. NPS is…
4. Which DAX function avoids a divide-by-zero error?