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
jbocachica's avatar
jbocachica
Resolver II
8 years ago

But you are trying to get the difference between a Column and a Measure?, is CPC a Column or a Measure?, if it's a Column, you should create a Measure to achive that.

 

Regards

  • morther's avatar
    morther
    Helper I
    8 years ago

    CPC is a column, but Drive_Station[TotMP] is a measure.