cancel
Showing results for
Did you mean:
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%

1 ACCEPTED SOLUTION

Accepted Solutions
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

## 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.
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
Frequent Visitor

## Re: Weekly Scrap Percent of Gross Production

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