Filters that use Measures to filter Members (Filter By Measure, Ranking Filters and Percentile Filters) behave in a 'For Each' fashion when placed after other Fields in a Pivot. This means that they are applied separately on each Member from Dimensions appearing before it.
To better understand this behavior, consider the following pivot data, that shows product sales per store:
| [Store] | [Product] | [Sales] |
| Store A | Food | 100 |
| Store A | Drink | 200 |
| Store B | Food | 400 |
| Store B | Drink | 300 |
Applying the filter 'Sales Greater than 600' (Filter By Measure) on the [Store] field will yield the following results:
| [Store] | [Product] | [Sales] |
| Store B | Food | 400 |
| Store B | Drink | 300 |
Because the [Store] field is placed first, the Sales Measure in the filter is evaluated for each store without regard to products (Store A=300, Store B=700).
Similarly, applying the filter 'Top Store in terms of Sales' (Top Ranking) on the [Store] field will yield the following results:
| [Store] | [Product] | [Sales] |
| Store B | Food | 400 |
| Store B | Drink | 300 |
Applying the filter 'Sales Greater than or equal to 200' (Filter By Measure) on the [Product] field will yield the following results:
| [Store] | [Product] | [Sales] |
| Store A | Drink | 200 |
| Store B | Food | 400 |
| Store B | Drink | 300 |
Because the [Product] field is placed after the [Store] field, the Sales Measure in the filter is evaluated for each product in the context of the store preceding it (Store A/Food=100, Store A/Drink=200, Store B/Food=400, Store B/Drink=300).
Similarly, applying the filter 'Top Product in terms of Sales' (Top Ranking) will yield the following results:
| [Store] | [Product] | [Sales] |
| Store A | Drink | 200 |
| Store B | Food | 400 |
Note that each store has a different top selling product. This is because the Top Ranking filter on the [Products] field is evaluated for each store individually.
Overriding This Behavior
If you wish a filter to be performed over all Members in a preceding field, instead of each Member individually, specify the All Member for the preceding field in the Measure's background:
