Guided Notes

DAX Measures for Healthcare KPIs

Measures vs calculated columns, CALCULATE and filter context, DIVIDE, DISTINCTCOUNT, time intelligence, and writing readmission, LOS and PMPM measures.

Measures vs calculated columns

Slide 1 / 5

• Calculated column: computed row by row when data refreshes (e.g. AgeBand from age). Stored in the model. • Measure: computed at query time in the current filter context (e.g. Readmission %). Responds to slicers. Rule of thumb: use measures for anything you aggregate or show as a KPI.

← Power BI Fundamentals