Advanced DAX, Evaluation Context & DAX Query View

Instructor: Alaa Hady · Language: English or Arabic · Suggested duration: 2 days · Level: Advanced (Level 300)

Objectives

• Master complex interactions between Row Context, Filter Context, and Context Transition.
• Author virtual tables, advanced iterators, and reusable Calculation Groups.
• Write, profile, and debug multi-table DAX queries using the native DAX Query View.
• Solve complex analytical scenarios including dynamic segmentation, basket analysis, and custom calendars.

Outline and contents

1. Deep dive into the VertiPaq engine: Formula Engine (FE) vs. Storage Engine (SE)
2. Context Transition mechanics and hidden CALCULATE pitfalls
3. Advanced CALCULATE modifiers: ALLSELECTED shadow filter contexts, ALLEXCEPT, TREATAS, CROSSFILTER, and USERELATIONSHIP
4. Table functions and Virtual Tables: FILTER, VALUES, DISTINCT, SUMMARIZECOLUMNS, ADDCOLUMNS, GENERATE
5. Mastering Calculation Groups and Dynamic Format Strings to eliminate measure proliferation
6. Advanced Windowing functions (WINDOW, INDEX, OFFSET, RANK, ROWNUMBER) vs. classic RANKX
7. Dynamic banding, ABC/Pareto classification, Market Basket Analysis, and New vs. Returning customer patterns
8. Custom non-standard 4-4-5 / ISO-8601 weekly time intelligence in pure DAX
9. Mastering DAX Query View: DEFINE, EVALUATE, MPARAMETER, and auto-generating test queries
10. Intensive debugging clinic using real-world broken DAX measures

Target audience

Experienced Power BI developers, analytics engineers, and data modellers comfortable with foundational DAX and Star Schemas.

Expected outcomes

Participants can predict exact DAX evaluation behavior in any visual context, replace dozens of redundant measures with Calculation Groups, and engineer high-speed formulas for complex business logic.