DAX formula to do % of total by multiple filters

[Slizer6893]

I am stumped right now.

I have fairly straight forward data these are the order of the columns at the moment

Date (Relative Month)
Plant Location
Product Group
Type
Color
Scrapped
Received

I need to summarize data as follows

By Date/Plant
Product Group/Type/Color : Scrap/Received so a % of scrap to received for that

So I would think the sum should be product group/type/color. Then divide the columns but I can not get it to work that way.

I also need to ignore any zeroes in the received column but that is achieved through my iferror. The big issue I am running into is its doing a totaled percentage. So it sums up all the percents instead of recalculating the totals then dividing again.

Basically it needs the ability to look at Product Group totaled....then product group-type totaled...then all 3

Any ideas?

Thank you ahead of time

 

[scottsen]

So, let's get specific. What does not work about this?

Total Scrapped := SUM(Table1[Scrapped])
Total Received := SUM(Table1[Received])
% Scrapped := DIVIDE([Total Scrapped], [Total Received])

 

[Slizer6893]

When I bring it into a pivot table. I want it to be able to not sum the %'s of an entire category. I would like to be able to look at the data at all different levels but it just adds up the percentages...there should never be 5250% scrapped items that doesn't make sense. I also know some of the data is iffy so I need to fix it on that side as well.

 

[scottsen]

I can't imagine a place in the pivot table that would give you that... without bad data. I'm happy to look at a workbook if you think me wrong. (Share via OneDrive, DropBox, GoogleDrive, etc)

 

[Slizer6893]

We are doing monthly financials but I will try and work up a scrubbed version after this week. I may be doing something small wrong causing it not to work. Just seems odd its happening this way.