cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bbollmann Frequent Visitor
Frequent Visitor

Weekly Scrap Percent of Gross Production

Greetings!  Given the Scrap Table and Production Table below (that could be combined into one data source if best), what formula will give me the Scrap Percent of Gross for the week.  For example, Nicks for 03/26 should be 106 / 900 = 11.77%, and Porosity for 3/19 should be 235 / 1450 = 16.21%

 

 

Power BI - Scrap Pct of Gross - 01.PNG

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Weekly Scrap Percent of Gross Production

Hi @bbollmann,

 

You need a date table. Then the measure could be as below. If you want more accurate solution, please provide a dummy sample.

Percentage =
SUM ( scrap[quantity] ) / SUM ( production[quantity] )

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: Weekly Scrap Percent of Gross Production

Hi @bbollmann,

 

You need a date table. Then the measure could be as below. If you want more accurate solution, please provide a dummy sample.

Percentage =
SUM ( scrap[quantity] ) / SUM ( production[quantity] )

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bbollmann Frequent Visitor
Frequent Visitor

Re: Weekly Scrap Percent of Gross Production

Thanks Dale,

 

New here, so not sure of best way to get a dummy.  Copied .pbix out to here:

 

https://1drv.ms/u/s!Ai7H4DJiU2zVaxNOcYSa953u_H8

 

Highlighted
bbollmann Frequent Visitor
Frequent Visitor

Re: Weekly Scrap Percent of Gross Production

@v-jiascu-msft, any chance you could take a look at the file I uploaded?