I have been trying to figure out how to sum the values of a product across multiple lines. I have tried many different forums with similar requests, but I can't seem to get the correct answer. Could possibly be my relationships, but I'm unsure. Any help is greatly appreciated!
This first image is my current formula. The answer I'm getting is the total quantity requested for the individual products. I want it to sum the quantity requested in relation to the Product: Product Name and the SSP Name
This image is showing the quantity requested for this person. The answer I should be getting in the first image is 204 for Shock Sensor 2 for Aaron Shaw, but I continue to get 86,092. That is the sum of all the requested Shock 2 Sensors and I'm out of formulas and attempts and approaches.
Based on your description, grouping only needs to be nested in a ALLEXCEPT function. Please try:
Total Requested=
CALCULATE(SUM('MTD Purchase Report-ALL'[Quantity Requested]), ALLEXCEPT( 'MTD Purchase Report- ALL', 'MTD Purchase Report-ALL'[SSP Name],'MTDPurchase Report-ALL'[Product:Product Name]))
I tried this a few times thinking I was doing something wrong, but it won't work for me for some reason. It still returns the total requested for each product.
Could you provide sample data or a sample pbix after removing sensitive data?
Hello @gmark ,
Have you tried "Group By" in the "Transform" tab. If you go for advanced group by, you can by name and product and perform aggregations.
Hello xander2121, I did try that but I don't want it to eliminate those columns. When I did that it grouped the columns and I need it to group rows.
@gmark https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M6071...
Questions with sample data moves really first in this forum
