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 r...
Need Help
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.])

    • sandra_gc's avatar
      sandra_gc
      Advocate I
      9 years ago

      Seb thank you, this worked very fine for me.