DAX - sum measures

[Andrew_OCP]

Hi

I have a measure called Weighted Productivty. As you can see in the below screenshot. The measure is being calculated correctly. However I would like an additional column that shows the same row values, i.e 28.63,-58.42,-6.47, but sums the total as -36.27, rather than the current total of -26.68% (which is being calculated correctly).

How can I just use the calculated value and aggregate it in another column. Could I use a cumulative value on the measure. Any advice much appreciated.

Thanks

Andrew

[Seb]

Hi Andrew,

I've just come across your question regarding summing measures. Did you ever manage to resolve? If so I'd be very interested in understanding how as I kepp banging my head against a brick wall with this. 

thanks

Paul

[Seb]

Hi, 

Just in case anyone views my question; I've managed to resolve the issue. I have a measure called margin variance and to get it to total for each category as opposed to just complete the variance calculation is to use:

Margin Var. = SUMX(VALUES('Power BI Item Ledger Entry'[Item Number]),[Margin Var Calc.])

[sandra_gc]

@Seb thank you, this worked very fine for me.