22-25 April 2026 
SQLBits 2024
Advanced DAX
Unleash the full power of evaluation context manipulation, learn about expanded tables, control the data lineage, avoid circular dependencies, and manage relationships at different granularities.
If you already know and use the DAX but want to move to the next level, this training day is for you.
Unleash the full power of evaluation context manipulation, learn about expanded tables, control the data lineage, avoid circular dependencies, and manage relationships at different granularities.
The prerequisite to attend this training is good experience writing DAX measures in Power BI or Analysis Services. You must know row context, filter context, and context transition. You are comfortable with using CALCULATE. You are not afraid to learn something new. At the minimum, watch the free "Introducing DAX" video course and make weeks of practice before attending this training.
Here are a few examples of what you can learn in this workshop:
• Filter columns, not tables. Yes, you already know that, but you will learn many more reasons why it is a good idea.
• Understand when to use ALLEXCEPT, and what to use instead of ALLEXCEPT all the many times when ALLEXCEPT is not a good idea.
• Fix the circular dependency error that might appear when you create a relationship, a calculated column, or a table.
• Control data lineage and play with it by using TREATAS.
• Write granularity-aware measures when you use many-to-many cardinality relationships (yes, you can if you know what you are doing).
Unleash the full power of evaluation context manipulation, learn about expanded tables, control the data lineage, avoid circular dependencies, and manage relationships at different granularities.
The prerequisite to attend this training is good experience writing DAX measures in Power BI or Analysis Services. You must know row context, filter context, and context transition. You are comfortable with using CALCULATE. You are not afraid to learn something new. At the minimum, watch the free "Introducing DAX" video course and make weeks of practice before attending this training.
Here are a few examples of what you can learn in this workshop:
• Filter columns, not tables. Yes, you already know that, but you will learn many more reasons why it is a good idea.
• Understand when to use ALLEXCEPT, and what to use instead of ALLEXCEPT all the many times when ALLEXCEPT is not a good idea.
• Fix the circular dependency error that might appear when you create a relationship, a calculated column, or a table.
• Control data lineage and play with it by using TREATAS.
• Write granularity-aware measures when you use many-to-many cardinality relationships (yes, you can if you know what you are doing).
Speakers
Marco Russo's previous sessions
Advanced DAX
Unleash the full power of evaluation context manipulation, learn about expanded tables, control the data lineage, avoid circular dependencies, and manage relationships at different granularities.
Aggregations in Power BI
Introduce Power BI aggregations with practical examples, evaluate pros and cons, and learn how to use alternative approaches by using DAX to control the aggregation used.
Using ALLEXCEPT or ALL/VALUES?
Learn when to use ALL / VALUES instead of ALLEXCEPT in DAX calculations.
Understanding window functions in DAX
Introduction to DAX window functions and apply semantics through several examples to understand their capabilities and performance.