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

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
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" )
)