Order of Evaluation in DAX & Variables

RACHEL DYER (CSG Pro)

 

Rachel Dyer is the Vice President of Analytics at CSG Pro with in-depth expertise of the Microsoft BI stack and dimensional modeling. She has a broad management background and strong communications skills, coupled with considerable technical experience in platform implementation. She is more commonly known as the Queen of DAX or Rachel DAXie Dyer. 

 

What order does DAX use when you nest more than one CALCULATE function? How does it behave when context transition is also happening at the same time? We’ll look at how this works and give you the logic and some examples.

Variables are so important that they were the driving force behind a new edition of The Definitive Guide to DAX that is in the works. We’ll review the fundamentals of variables and show some common use cases that you are sure to run into.

Share this:
Rachel Dyer
Rachel Dyer
racheld@csgpro.com

Rachel Dyer is the VP of Analytics, but she is more commonly known as the Queen of DAX. With over 20 years of experience in data warehouse design and execution, Rachel has in-depth expertise of the Microsoft BI stack and dimensional modeling. She combines her strong communication skills with her technical experience in platform implementation to help clients overcome their data challenges.



Ready to wrangle your data?