The Fundamentals of DAX Contexts
summary
A concise, demo-first primer that uses a 12-photo dataset in Power BI to demonstrate why the same DAX measure returns different numbers: filter context picks the rows, row context iterates them, and calculate modifies filter context to add, remove or override filters. Examples show concrete results (12 total photos, 45 total subjects, 2 black-subject photos) and patterns: replace calculated columns with AVERAGEX iterator to avoid enlarging the model, use CROSSFILTER to change relationship direction, and use row-to-filter context transitions to compare counts.
AI-written summary · about
chapters (9)
- 0:00Introduction and setup
- 1:51Session agenda and goals
- 3:50Understanding evaluation context
- 8:10Data set overview
- 10:14Deep dive into filter context
- 19:31Exploring row context
- 26:50Using the calculate function
- 38:15Modifying relationships
- 43:44Context transitions and wrap-up
related talks
19mDAX in 20 Minutes - The Hard Parts
51mData modeling for experts with Power BI
01h 05mDynamic Presentation Using Excel CUBE Formulas
20mDemystifying Power BI Slicers and filters
54mData Visualization with Power View and the Tabular Model
51mPower BI Composite and Hybrid Models
50mDo You Speak English? Localized Reports with Power BI
45mMagnificent 7 - Simple Tricks to boost your Power BI Development