Forum Discussion

Wildglen's avatar
Wildglen
Regular Visitor
9 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(FILTE...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Wildglen

     

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

     

    Regards, 

     

    Matt

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Wildglen

 

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

 

Regards, 

 

Matt