The word context is derived from the Latin word contextus, which means closely connected or interwoven. In modern language, context is the setting or the set of circumstances around an event.
In DAX, when we talk about the evaluation context, we're talking about the set of circumstances under which a DAX expression is evaluated, brought about by the state of filters, slicers, interactions with visuals, and row and column selections.
In Chapter 1, What is DAX?, we took a brief look at the two types of evaluation context that exist in DAX, which are the following:
- The row context
- The filter context
In this chapter, we'll look at these in more detail. We will use examples to help us understand how changes in context change the results that we get back from DAX expressions when they are evaluated within that context.
Strictly...