Microsoft Office Tutorials and References
In Depth Information
Well, consider a further selection on the PivotTable wherein the Size attribute is filtered by
Large. In Figure 6-34, you can see the result of this last QtyGreen definition.
FIguRE 6-34 The result using the FILTER on the Orders table seems to be the same as the previous definition
of QtyGreenFiltered.
Now let us add another filter to the CALCULATE function so that we also filter the rows with
Size equal to Small, defining a QtyGreenSmall measure.
CALCULATE( SUM( Orders[Quantity] ),
FILTER( Orders, Orders[Color] = "Green" ),
Orders[Size] = "Small" )
As you have seen before, that definition corresponds to the following:
CALCULATE( SUM( Orders[Quantity] ),
FILTER( Orders, Orders[Color] = "Green" ),
FILTER( ALL( Orders[Size] ), Orders[Size] = "Small" ) )
The result is that the filter for Large defined in the PivotTable plus the filter for Small defined
in the QtyGreenSmall measure returns no rows at all in the measure result, as you can see in
Figure 6-35. If you think about it, this behavior is not very intuitive.
Search JabSto ::

Custom Search