DAX Fundamentals & Healthcare KPIs

Learning Objectives

• Write basic DAX measures using SUM, COUNT, AVERAGE, and DISTINCTCOUNT
• Explain the difference between a calculated column and a measure
• Use CALCULATE to change filter context
• Build a working set of core hospital KPI measures

Key Topics Covered

• DAX syntax basics
• Calculated columns vs. measures
• Aggregation functions
• CALCULATE and filter context
• DIVIDE for safe percentage calculations
• Formatting measures (currency, percent)