Microsoft Office Tutorials and References
In Depth Information
FIguRE 6-7 Correct definition of measure using SUMX.
In Figure 6-7, we used the SUMX function to apply our initial expression to each of the
rows of the Orders table that are active in the current filter context, and as you can see
in Figure 6-8, the CalcAmount measure works fine.
FIguRE 6-8 Resulting value of the CalcAmount measure.
You need to understand that the filter context defined by the coordinates of each cell in
the PivotTable is used, during the computation of the SUMX function, to filter the rows of the
Orders table. So this is the crux of the matter: the expression in the SUMX function has been
evaluated under both a filter context and a row context.