Measured with different Filters

[Syndicate_Admin]

Good morning, I need help. I need to create a measure that adds the column Balances [BALANCE] but that is not affected by the segmenters of the page and that does not add the data when the element of Balances[OFI_DESCRIPCION] is equal to 'Headquarters', I tried with this measure but I need to add that I do not add 'Headquarters':

Balance = CALCULATE(sum(Balances[BALANCE]), ALL(Balances[DESCRIPCION_ZONA],Balances[OFI_DESCRIPCION]))

[Syndicate_Admin]

Thank you very much, it guided me a lot and helped me a lot

[DataInsights · Accepted solution]

@bcastrom,

If you want to clear the filter context from all segmenters (slicers and filters), you can use the ALL function:

Balance =
CALCULATE (
    SUM ( Balances[BALANCE] ),
    ALL (),
    Balances[OFI_DESCRIPCION] <> "Headquarters"
)