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 filtered MoMdiff > 0.

 

 

I would like to sum and isoleted the positive numbers and negative numbers to have a card that displays both sum for better analysis.

 

Please it would be great if some one could help me.

 

Thank you in advance

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] )

3 Replies

  • 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] )