Hard Code a Dax formula, not to be filtered by slicer

[Anonymous]

Hello,

I am trying to create a calculated formula In order to have it static and not be filtered by slicer.

I want to calculate "01. CAB" and not to change when I filter it with  'PL Transactions Brand_Marketing_V' [Brand]

BrandMarketing CAB =

CALCULATE(SUM('PL Transactions Brand_Marketing_V'[Amount]),FILTER(ALL('PL Transactions Brand_Marketing_V'),'PL Transactions Brand_Marketing_V'[Level 1]="01. CAB"))

The problem with the formula above is that is not taking in consideration the relative date filter aplied on the page (in this year).

Thank you!

[Anonymous]

Thank you! Didn't know about removefilters function.

[johnt75 · Accepted solution]

You can try

BrandMarketing CAB =
CALCULATE (
    SUM ( 'PL Transactions Brand_Marketing_V'[Amount] ),
    REMOVEFILTERS ( 'PL Transactions Brand_Marketing_V'[Brand] ),
    'PL Transactions Brand_Marketing_V'[Level 1] = "01. CAB"
)