Sum column values based on another column

Neftali — Wed, 03 Aug 2022 16:19:41 GMT

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?

Re: Sum column values based on another column

johnt75 — Thu, 04 Aug 2022 08:09:44 GMT

You can create a measure like

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

and put that into a visual with the Material Name

topic Sum column values based on another column in DAX Commands and Tips

Sum column values based on another column

Re: Sum column values based on another column