DAX to sum up a value grouped by another column

[PhoenixBird66]

I want to create a new column called [KG of Batch] which sums up the values from another column [WeightOfBatchLine], grouped by another column [Batch Header No]. All of these fields are on the same table.

See the example in my picture below.

Any help greatly appreciated.

[ZunzunUOC · Accepted solution]

Hi @PhoenixBird66 , you can use the next calculated column:

KG of Batch = 
var VarId='Batch'[Batch Header No.]
return
CALCULATE(SUM('Batch'[WeightOfBatchLine]);FILTER('Batch';'Batch'[Batch Header No.]=VarId))

Best Regards,
Miguel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.