Sum filtered by a column

[Anonymous]

Hi,

Here is a sample of my table. 

I want to sum the volume for each Lot and get a visual where we can see each length with total of volume of all rows of the Lot. I create this measure but the total is for all the Lot. The expected result is 83762. What is wrong?

Measure 1 = CALCULATE(SUMX(Table1;Table1[Volume];ALLEXCEPT(Table1;Table1[LOT]))

Thanks

[Anonymous · Accepted solution]

Find it...

I create a new table with a column call Lot and another one call Sum of volume. That works.