Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sum filtered by a column

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

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Find it...

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

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Find it...

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