Forum Discussion

Spencer's avatar
Spencer
Helper II
9 years ago
Solved

Simple Sum Filter

Hi   If I have a dataset like the following: Status         Qty P                   10 P                   20 M                  50 M                  30 C                   25 C            ...
Need Help
  • SanderBeukers's avatar
    SanderBeukers
    9 years ago

    Assuming your table is called "Table":

     

    Measure = CALCULATE(SUM('Table'[QTY]);'Table'[Status]<>"C";'Table'[Status]<>"D")

     

    CALCULATE() allows multiple filters

Spencer's avatar
Spencer
Helper II
9 years ago

Thanks for the reply Douwe but I don't think that will filter out the D's as well.

Douwe's avatar
Douwe
Helper I
9 years ago

Extend it like this: Sum = CALCULATE(SUM(Qty);FILTER(Status<>"C" || Status<>"D"))