Forum Discussion
Solved
Sum column values based on another column
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?
You can create a measure like
Total Qty = SUM( 'Table'[Total Qty Per Request])and put that into a visual with the Material Name
1 Reply
johnt75Super User
You can create a measure like
Total Qty = SUM( 'Table'[Total Qty Per Request])and put that into a visual with the Material Name