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.