O'Reilly logo

Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model by Alberto Ferrari Marco Russo and Chris Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required