Power BI: CALCULATE is ignoring my slicer — why?

Question

My measure:

```dax
Sales Bikes = CALCULATE([Total Sales], Product[Category] = "Bikes")
```

When the user picks "Accessories" in a Category slicer, this measure still shows bike sales. I expected it to be blank.

Accepted Answer

That's by design. A boolean filter argument in `CALCULATE` **replaces** any existing filter on that column. It's shorthand for `FILTER(ALL(Product[Category]), ...)`, so the slicer selection on `Category` is overwritten.

To **intersect** with the current selection instead, wrap it in `KEEPFILTERS`:

```dax
Sales Bikes =
CALCULATE([Total Sales], KEEPFILTERS(Product[Category] = "Bikes"))
```

Now if the slicer selects Accessories, the intersection is empty and the measure returns blank.

Rule of thumb: use `KEEPFILTERS` when the measure should *respect* user selections, and the plain form when it should *override* them (e.g. "% of Bikes" comparisons).

1 réponse