How to sum total by date only without filer

[sqaar__]

Hi - 

I'm struggling with I hope very easy task. 

I have two file with data. One collects all refabrication detail such, as quantity, code, and date.

Another file has only data and value on how many we produce this day. 

I need to count % of scrap, basically, all refabrication / all produced.

Total_Refabrication = SUM(rejected_AFAB_Sheet[Ilość])

Total_Aligner_Produced = SUMX(Produced_Sheet,Produced_Sheet[Produced])

Scrap = [Total_Refabrication]/[Total_Aligner_Produced]

I set up the relationship to count it correctly, without that, the value "Total_Aligner_Produced was always the same

But right now, I have a problem that each code count scrap only for part of daily produced, not from the total.

I.e

Weekly we made 19k

The top one by % show me AR12, which was 8 times, and the top 2 is MR which was 24 times

When I press AR12, produced value changes to 4502 instead of keeping total

 so the divider is smaller 

MR24 is 16K (still not total), but the divider is higher, so % is smaller even if the total is higher.

I tried to explain as much as I could.

Thank you in advance!

Regards,

Patryk

[sqaar__ · Accepted solution]

Solved,

Pretty simple,

CALCULATE(SUM(Produced_Sheet[Produced]),ALL(rejected_AFAB_Sheet))