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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
