Forum Discussion

Wildglen's avatar
Wildglen
Regular Visitor
8 years ago
Solved

Sum column with same ID

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?

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Wildglen

     

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

     

    Regards, 

     

    Matt

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Wildglen

     

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

     

    Regards, 

     

    Matt