Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

filtering a measure

SUMX(FILTER(Cancellations, Cancellations[status]="order confirmed"),1) Im trying to get a static figure for "order confirmed" even when i select other status's on another slicer, is this possible? ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    ALL  function should help you in your scenario, please refer to the online document.

    https://docs.microsoft.com/en-us/dax/all-function-dax

     

    Also one sample for your reference, here we can create a measure as below to work on it.

    Measure =
CALCULATE (
    SUM ( 'Table'[value] ),
    FILTER ( ALL ( 'Table' ), 'Table'[status] = "order confirmed" )
)

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

the simplest way, probably, is disconnect the visual from the filter/slicer in Format->Edit Interactions.

If you need other elements of the visual to react on the slicer, but this measure to stay the same. This is the DAX formula, which you can adapt to your scenario:

 

Measure = CALCULATE(sum('Table'[Column2]), All('Table'[Column1]), 'Table'[Column1] = 2)

However filter changes on the Column1, the measure keeps showing sum(Column2) for Column1=2 (respecting all other filters).

 

Kind regards,

JB