Changing context using DAX functions

Having covered the evaluation contexts in some detail, we are now going to look at some ways in which we can use DAX functions to change the evaluation context. We'll start off by looking at how we can change the behavior of an expression that is evaluated using the row context.

Context transition

You may remember that, at the start of this chapter, we looked at how an expression we used for a measure did not work in the same way when used in the definition of a calculated column. This is because calculated columns are evaluated using row context, and not filter context. However, it is possible to convert an expression from using the row context into using the filter context by wrapping...