filtering a measure

[Anonymous]

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? 

[v-frfei-msft · Accepted solution]

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]

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