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...
You can create a measure like
Total Qty = SUM( 'Table'[Total Qty Per Request])and put that into a visual with the Material Name
johnt75
Super User
Super UserYou can create a measure like
Total Qty = SUM( 'Table'[Total Qty Per Request])and put that into a visual with the Material Name