Forum Discussion

Andrew_OCP's avatar
Andrew_OCP
Regular Visitor
10 years ago

DAX - sum measures

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

 

Need Help

3 Replies

  • Seb's avatar
    Seb
    Regular Visitor
    9 years ago

    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's avatar
      Seb
      Regular Visitor
      9 years ago

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