SQLBI Days – Advanced DAX

Chicago, IL, US

Sorry, this course is closed.

Leave your email if you want to be notified when a new edition of SQLBI Days – Advanced DAX is available in United States.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

 By pressing the Notify button you are agreeing to our Privacy Policy.

SQLBI Days are an exceptional type of event we are launching in 2024. We are organizing one-day lectures of various levels, with Marco Russo or Alberto Ferrari on stage.

Learn more about SQLBI Days »

This Day is for you if you have already studied Mastering DAX, whether in the classroom or on-demand with the video course. The contents of this Day have been delivered only a few times in pre-conference workshops at international conferences in the past, and they have been refreshed and updated for you.

Marco or Alberto will challenge you in your existing knowledge of DAX. Together, you will revisit the important foundations of key concepts such as row context, filter context, context transition, and functions like CALCULATE and KEEPFILTERS, which many advanced users do not actually fully understand. You will gather insights about data lineage, expanded tables, dependencies in calculated columns and tables, and different types of relationships, and this will likely shed some light on challenges you may be facing in your work with DAX.

The goal of this Day is to consolidate the more advanced concepts of DAX so you can figure out how to solve more complex calculations in DAX, or identify why an existing measure in your model does not work as expected. This Day is a good preparation for SQLBI Days - First Steps in DAX Optimization.


  • Evaluation context review
  • CALCULATE and context transition review
  • CALCULATE execution order
  • Data lineage and TREATAS
  • Expanded table
  • Circular dependencies
  • Calculated relationships
  • Regular and limited relationships
  • Working at different granularity


  • Consolidated experience in DAX.
  • Previous completion of the Mastering DAX course or equivalent experience.
  • The initial review is a quick recap of the concepts that should be already well known: filter context, row context, context transition, CALCULATE.


Gleacher Center

450 North Cityfront Plaza Drive 60611
Chicago, IL, US
View on Google Maps

Teaching this course

Marco Russo

Consultant & Mentor
Trainer for 172 other courses at SQLBI

Looking for another city?

We bring our classroom courses to you all over the world. Here are the current scheduled classroom courses.
Please note that each classroom course is taught exclusively by SQLBI trainers in person. No external trainers are involved.
 Melbourne (Southbank), VIC 3006, AU Aug 9
Aug 6-8
 Sydney, NSW 2000, AU Aug 15
Aug 12-14
 Brisbane, QLD 4000, AU Aug 19-21
 Calgary, AB, CA Sep 18-20
 Vancouver, BC, CA Sep 23-25
 London, England, GB Oct 14-16
 New York City, NY, US Oct 30-Nov 1
New York City
 Los Angeles, CA, US Nov 12-14
Los Angeles
 Amsterdam, NL Nov 19-21
 Copenhagen, DK Dec 2-4
 Amsterdam, NL Dec 10-12
Other locations On-Site On-Site On-Site