Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Measured with different Filters

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]))

  • DataInsights's avatar
    DataInsights
    4 years ago

    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"
)

2 Replies

  • DataInsights's avatar
    DataInsights
    Super User
    4 years ago

    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"
)