Microsoft Office Tutorials and References
In Depth Information
FIguRE 6-3 The relationships between table rows and PivotTable cells.
So we can say that each selection that you make in a PivotTable (selection on columns, rows,
filters, and slicers) corresponds to a filter in the PowerPivot table. If a column of the table is
not used in any part of the PivotTable, there is no filter on that column.
In this first example, we considered only one table in the model. If you have more than one
table, your work gets more complicated, but before diving into that, let us introduce the
second kind of evaluation context: the row context.
Row Context in a Single Table
Row context is conceptually close to the idea of current row . When a calculation is applied
to a single row in a table, we say that there is a row context active for the calculation. This
means that if you reference a column in the table, you want to use the value of that column
in the current row. As you see later, there are certain DAX expressions that are meaningful
only when there is an active row context (like the simple reference of a column) and other
expressions that are valid only in the filter context, regardless of the active row context (for
example, the SUM aggregation function).
There are two cases when there is an active row context:
■ Evaluation of a calculated column
■ Evaluation of a DAX function that iterates over a table