Forum Discussion

morther's avatar
morther
Helper I
8 years ago

Finding the difference between two columns

This CPC column is filtering as I need it to, and there are no errors.   CPC = CALCULATE( COUNT(ImportCubicPM[CPC]), FILTER(ALL(ImportCubicPM[CPC]), ImportCubicPM[CPC] = "MP-MONTHLYPM-PM-"))   ...
Need Help
morther's avatar
morther
Helper I
8 years ago

This works when I subtract 2 columns

CPC = CALCULATE (Drive_Station[TotMP] - 
(COUNT(ImportCubicPM[CPC])))

This works when I Filter a column

CPC = CALCULATE(COUNT(ImportCubicPM[CPC]),
      FILTER(ALL(ImportCubicPM[CPC]),
        ImportCubicPM[CPC] = "MP-MONTHLYPM-PM-"))

 When I try to combine these 2 formulas, I receive an error "Operator or expression '()' is not supported in this context"

CPC = CALCULATE (Drive_Station[TotMP] - 
     (COUNT(ImportCubicPM[CPC]),
      FILTER(ALL(ImportCubicPM[CPC]),
        ImportCubicPM[CPC] = "MP-MONTHLYPM-PM-"))