Sum column with same ID

[Wildglen]

Hello,

I have the following table:

 

I'm trying to create a custom column which sums Hoeveelheid for items with the same SolutionID. So far I've come up with: 

Column = SUMX(FILTER(tbl_SolutionChemicals;tbl_SolutionChemicals[SolutionID]=tbl_SolutionChemicals[SolutionID]);tbl_SolutionChemicals[Hoeveelheid])

But this returns the sum of all Hoeveelheid rows. Can anyone help me with this?

[Anonymous · Accepted solution]

Hi @Wildglen

Try Sum Hoeveelheid 2 = CALCULATE(SUM(Table1[Hoeveelheid]),ALLEXCEPT(Table1,Table1[SolutionID]))

Regards, 

Matt