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

Douwe's avatar
Douwe
Helper I
9 years ago

Something like this should work:

 

Sum = CALCULATE(SUM(Qty);FILTER(Status=C))

  • 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.

    • SanderBeukers's avatar
      SanderBeukers
      Advocate I
      9 years ago

      Assuming your table is called "Table":

       

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

       

      CALCULATE() allows multiple filters

    • Douwe's avatar
      Douwe
      Helper I
      9 years ago

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