Sum Values month-over-month var

[dukealb]

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

[ryan_mayu · Accepted solution]

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

Hi Ryan,

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

Regards

[ryan_mayu]

you are welcome