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, 

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.