Hands-On Business Intelligence with DAX

Summary

In this chapter, we took a more in-depth look at evaluation contexts, focusing on the two different types of evaluation contexts: row context and filter context.

First, we took a detailed look at the row context, learning how this applies when you create a calculated column or use a function that iterates through the rows of a table. We followed this with a detailed look at the filter context, learning about the different sources of filters, and how these can affect the results coming back from a DAX expression. Then, we learned about the concept of expanded tables, and how these can help you to understand how filters can propagate through related tables. Finally, we looked at how you can change a context in DAX. We learned how you ...