cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sqaar__
New Member

How to sum total by date only without filer

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
sqaar___0-1664793475329.png

 

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

 

 

sqaar___1-1664793603296.pngsqaar___2-1664793615630.png

 

 

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

sqaar___3-1664793690562.png

 

 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.

sqaar___4-1664793715633.png

 

 

I tried to explain as much as I could.

Thank you in advance!

 

Regards,

Patryk

 

1 ACCEPTED SOLUTION
sqaar__
New Member

Solved,

 

Pretty simple,

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

View solution in original post

1 REPLY 1
sqaar__
New Member

Solved,

 

Pretty simple,

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

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.