Tecflix

Evaluation Contexts Purchase the entire course

29 October 2020 · · 96 views

Mastering DAX Workshop

Evaluation Contexts (Filter)

At this point in the course, you have learned the basics of the DAX language. You know how to create calculated columns and measures, and you have a good understanding of common functions used in DAX. With the knowledge you have gained so far, you can already create many insightful reports, but you will need to learn evaluation contexts in order to create more elaborate and complex reports. You will see that an evaluation context is made of both a filter context and a row context. Evaluation contexts are the basis for all advanced features in DAX.

A word of a warning: the concept of an evaluation context is an easy one, and you will learn and understand it soon. Nevertheless, you need to thoroughly understand several subtle considerations and details. Otherwise, you are likely to feel lost at a certain point on your DAX learning path.

Evaluation contexts play an important role with the use of the CALCULATE function, which you will meet in the next module.

Log in or purchase access to play the video.

  • Introduction to Mastering DAX 2nd Edition 5-min Free—Watch Now

  • Introduction to DAX 1-hour 46-min Watch with Free Subscription

  • Exercises, Labs, Demos, and Presentation Slides 52-min

  • Exercises for: Introduction to DAX 52-min Watch with Free Subscription

  • Table Functions 1-hour 9-min

  • Exercises for: Table Functions 44-min

  • Evaluation Contexts 57-min

  • Exercises for: Evaluation Contexts 29-min

  • The CALCULATE Function 1-hour 4-min

  • Exercises for: The CALCULATE Function 49-min

  • Advanced Evaluation Contexts 56-min

  • Exercises for: Advanced Evaluation Contexts 1-hour 5-min

  • Iterators 41-min

  • Exercises for: Iterators 39-min

  • Building a Date Table 37-min

  • Time Intelligence in DAX 1-hour 20-min

  • Exercises for: Time Intelligence in DAX 46-min

  • Hierarchies in DAX 37-min

  • Querying with DAX 1-hour 58-min

  • Exercises for: Querying with DAX 47-min

  • Data Lineage and TREATAS 13-min

  • Expanded Tables 34-min

  • Exercises for: Expanded Tables 15-min

  • Segmentation 36-min

  • Exercises for: Segmentation 14-min

  • Many-to-many Relationships 35-min

  • Exercises for: Many-to-Many Relationships 13-min

  • Advanced Filtering 49-min

  • Relationships at Different Granularities 1-hour 20-min

  • Additional Exercises 27-min

  • Calculation Groups 1-hour 27-min

  • Exercises for: Calculation Groups 57-min

Purchase a Full Access Subscription

 
Individual Subscription

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase
 
  • You can also redeem a prepaid code.
  • Payments are instant and you will receive a tax invoice straight away.
  • We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.
  • See pricing FAQ for more detail.
In collaboration with
Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo