CODEWITHSUNDEEP
dax
Randy Minder
Randy Minder

Reputation: 48422

Calculate with filter but ignore existing filters

I have DAX measure that looks as follows:

61 to 90 Days = CALCULATE(Sum(AccountsPayableDocument[DocumentBalance]), AgingBucket2[BucketId] = 4).

I want this measure to ignore any existing filters in place set by a slicer and just use the filter specified. I know this can be done, and I've seen it done before on videos, but can't, at the moment, remember out how.

Upvotes: 0

Views: 2588

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

That's what the ALL function is for. It removes any filters on the table or column specified inside the parentheses.

61 to 90 Days =
CALCULATE(
    SUM(AccountsPayableDocument[DocumentBalance]),
    ALL(AccountsPayableDocument),
    AgingBucket2[BucketId] = 4
)

Upvotes: 1

Related Questions