Filter Context

One of PowerPivot for Excel’s unique behaviors is the use of the filter context to dynamically transform a calculation to take advantage of additional row (or column) labels and slicer values. DAX includes no concept of cell addressing. Instead, relationships between tables and filter context combine to create an environment for formula evaluation. One way to understand filter context is the row and column context created by both data labels in addition to any applicable slicer values. Considering my fanatic obsession with NCAA football, it is my hope the example in this section will both illustrate filter context and be readily applied to composition analysis.

Using the Roster table from the earlier example in this chapter, we ...

Get PowerPivot for Business Intelligence Using Excel and SharePoint now with O’Reilly online learning.

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