Calculate sum of a column based on two column

[Anonymous]

Hi, how do I calculate Sum based on two columns.

Example (above) and expected output (bottom) :

Should I use Measure? Or create a new table instead?

Thanks!

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Please make sure the aggregation for 'Product_Code' is set as 'Don't summerize' and the aggregation for 'Product Qty' is set as 'Sum'.

Or you may create a measure as below.

Result = SUM('Table'[Product_Qty])

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You can choose aggregation as sum or create a measure

Total product qty = Sum(Table[product_qty])

Take the other two as (so not summarize) in a table or on the row of the matrix visual .

[az38]

Hi @Anonymous 

just set aggregation as Sum in visual field Product_Qty settings