Chapter 7. DAX Advanced

In the previous chapter, you learned how to query a Tabular model in both DAX and MDX. When you write a measure in a Tabular model, the measure can be executed in different contexts, and it is important to understand how to interact with them in your calculation. This is a significant skill to learn, regardless of whether the measure is defined in the model or defined locally to a query.

In this chapter, you gain more insight into manipulating filter context with CALCULATE and CALCULATETABLE, you see how to control filters and selection, and you learn how the row and filter contexts are used when an MDX query is evaluated. Finally, you learn other DAX functions to control ranking-based filtering of elements and to perform ...

Get Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.