Sum column values based on another column

[Neftali]

Hi all

I have this data and I want to sum "Total Qty Per Request" based on the "Material Name." So I want the sum of the "Total Qty Per Request" for "Bot Bev G5," "Dexron LS Gear Oil 75W-90," etc. How would I be able to make a measure for this?

[johnt75 · Accepted solution]

You can create a measure like

Total Qty = SUM( 'Table'[Total Qty Per Request])

and put that into a visual with the Material Name