Forum Discussion

dukealb's avatar
dukealb
Regular Visitor
4 years ago
Solved

Sum Values month-over-month var

Hi I'm still a simple user of powebi, I created a measure to calculate the Month-over-month cost variation (MoMDiff) and in the results I have negative and positives numbers. The table below is fi...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    dukealb 

    maybe you can try this

    Measure = sumx(FILTER(VALUES('Table'[resourceid]),[MoMDiff]>0),[MoMDiff] )

Measure 2 = SUMX(FILTER(VALUES('Table'[resourceid]),[MoMDiff]<0),[MoMDiff] )

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
4 years ago

dukealb 

maybe you can try this

Measure = sumx(FILTER(VALUES('Table'[resourceid]),[MoMDiff]>0),[MoMDiff] )

Measure 2 = SUMX(FILTER(VALUES('Table'[resourceid]),[MoMDiff]<0),[MoMDiff] )

  • dukealb's avatar
    dukealb
    Regular Visitor
    4 years ago

    Hi Ryan,

     

    Thank you so much for your awnser, it worked fine.

    Regards

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      4 years ago

      you are welcome