22.12 How All Filters Combine

Filters on all pages: Platform = Blinkit
AND slicer: City = Pune
AND Filters on this visual: Order Status = Delivered

In simple words (sopya bhashet)

Step by step: how Power BI decides what a visual shows

1. Start with every row of the fact table (for example all order rows).
2. RLS keeps only the rows this user is allowed to see (Module 26). A measure cannot remove this layer.
3. Report-level filters (Filters on all pages) remove more rows.
4. Page-level filters (Filters on this page) remove more rows.
5. Slicers and cross-filtering from other visuals remove more rows, depending on Edit interactions (22.10).
6. Visual-level filters (Filters on this visual) remove the last rows.
7. The measure is calculated on whatever is left. Inside the measure, CALCULATE can remove or change some of these filters (not RLS).

One important detail: filters on different fields combine with AND, but several values ticked in the same slicer combine with OR (Pune or Nashik). Mhanje: across filters AND, inside one slicer OR.

Worked example 1 – Blinkit dairy orders, Pune (fictional): peeling the layers

Suppose we are the Blinkit dairy category team in Pune (fictional practice data). Orders come from two apps: Blinkit and Swiggy Instamart. The table DairyOrders has 8 rows:

The "Milk Sales" card sits on a page with a page filter Product = Milk, a City slicer set to Pune, and a visual filter Amount ≥ 100 on the card. Watch what each layer does to Total Amount = SUM(DairyOrders[Amount]):

The card shows ₹540 because a row must pass all filters (AND). Now set the card to None for the City slicer (Format › Edit interactions). The card skips the slicer. Rows 101, 104, 105 and 108 remain, and the card shows ₹840.

Worked example 2 – Nashik Valley Grapes (fictional exporter): OR inside a slicer, AND across slicers

A fictional Nashik grape exporter tracks shipments in the table Shipments:

• Variety slicer: Thompson Seedless and Sharad Seedless both ticked, then inside the slicer this means Thompson OR Sharad (S1, S2, S3, S5 = 35 tonnes).
• Add a Market slicer = Europe, then now Variety (Thompson or Sharad) AND Market = Europe, then S1 + S2 = 20 tonnes.

To show "all markets" next to it while the Market slicer stays on the page, remove only that one filter inside a measure:

Total Tonnes = SUM(Shipments[Tonnes])
All Markets Tonnes = CALCULATE([Total Tonnes], REMOVEFILTERS(Shipments[Market]))

With the same selections, All Markets Tonnes returns 35 (the Variety filter still applies, only Market is removed). If an RLS role limited this user to Europe, even REMOVEFILTERS could not bring the Middle East rows back.

Common mistake – Panchganga Gul Bhandar, Kolhapur (fictional): the blank card

The owner of a fictional Kolhapur jaggery shop opens the report, picks 2025 in the Year slicer, and the "Sales" card says (Blank). The data is fine. The cause: while designing, someone added a hidden page filter Year = 2024 and forgot it. Year = 2024 AND Year = 2025 can never both be true, so no row survives.

How to find it, layer by layer:

1. Open the Filters pane in Desktop and look at Filters on this visual, on this page and on all pages (hidden filters are visible to you as the author).
2. Check the slicers on the page, and synced slicers from other pages (22.9).
3. Check Edit interactions: is another visual cross-filtering this card?
4. If the report has RLS, use Modeling › View as with the role to test (Module 26).

Remove the forgotten Year = 2024 page filter and the card shows 2025 sales again.