DAX Fundamentals: Measures, Context & Visual Calculations

Instructor: Alaa Hady · Language: English or Arabic · Suggested duration: 1–2 days · Level: Intermediate (Level 200)

Objectives

• Master how the DAX engine evaluates Row Context and Filter Context.
• Write robust business measures for ratios, variances, and time comparisons.
• Know when to use model-level DAX measures versus visual-level Visual Calculations.
• Use VAR (variables) and DAX Query View to write clean, debuggable formulas.

Outline and contents

1. DAX architecture: measures vs. calculated columns vs. Visual Calculations
2. Understanding Evaluation Context: Filter Context and Row Context demystified
3. Standard aggregations (SUM, DISTINCTCOUNT) vs. Iterator functions (SUMX, AVERAGEX, RANKX)
4. CALCULATE as the superpower of DAX: adding, overwriting, and removing filters (ALL, ALLSELECTED, REMOVEFILTERS, KEEPFILTERS)
5. Safe conditional logic and error handling: DIVIDE, IF, SWITCH(TRUE()), COALESCE
6. Percentages of total, parent contributions, and dynamic baselines
7. Core Time Intelligence: TOTALYTD, SAMEPERIODLASTYEAR, DATEADD, and period-over-period variance
8. Visual Calculations (RUNNINGSUM, MOVINGAVERAGE, PREVIOUS, VERSUS) for rapid in-visual metrics
9. Writing readable code with VAR/RETURN and testing outputs in DAX Query View
10. Guided KPI calculation workshop

Target audience

Power BI report developers and analysts with basic familiarity with tables, relationships, and visuals.

Expected outcomes

Participants can write and explain core DAX measures confidently, modify filter context intentionally with CALCULATE, leverage Visual Calculations appropriately, and validate calculation accuracy.