How to sum up specific column of the table

[kusanagi]

I would like to sum the product based on "Product" column only.

Here is what I have in power bi.

And this is what I want to add.

Product total is the sum of the product, doesn't matter which lot it's from.

This is the original idea from excel

[Ahmedx · Accepted solution]

pls try this

[Anonymous · Accepted solution]

@kusanagi  Please try this calculated column:

Product Total =

CALCULATE (

    SUM ( Sheet1[Count of Product] ),

    ALLEXCEPT ( Sheet1, Sheet1[Product] )

)

[Ahmedx · Accepted solution]

or try this

[Anonymous · Accepted solution]

@kusanagi  Please try this calculated column:

Product Total =

CALCULATE (

    SUM ( Sheet1[Count of Product] ),

    ALLEXCEPT ( Sheet1, Sheet1[Product] )

)

[Ahmedx · Accepted solution]

pls try this