Sum up multi connections and filter by slicer

[Xiaolong]

Hello there community, 

I'm beginning to use PowerBI and I am reading the content for quite a while, which normally helps, thanks for that 🙂

But now I'm stuck and don't  know how to achieve my goal. First things first: 

I try to visualize and compare the delivered quality of our suppliers given a specified time frame. For this have 3 tables available in my data model:

Table 1 is a master table with dates. For every day of the year we get a varety of different other stuff as day of week, day of month, day of year, fiscal quarter etc. etc.  This table is used for filtering and displaying the relevant data.

Times (Mastertable)

Calendar day	Fiscal week	Calendar month	etc.
02.05.2022	2022 - WK31	May	...
03.05.2022	2022 - WK31	May	...

Table 2 is a table where all deliveries are stored which we received and the relevant data here is: 

Deliveries (All)

Database Key	Delivery date	Itemnumber	Quantitiy Received	Supplier Name	Supplier ID
X	03.10.2021	123456	15	Supplier A	10
Y	05.06.2022	654321	12	Supplier B	11

Finally I got table 3, which stores all data related to the defect reports we are creating in case we find something unusual to the products:

Defects (All)

Defect ID	Creation Date	Affected item	Affected quantity	Supplier ID	Some other stuff
AAA001	04.10.2021	123456	4	10	...
AAA002	07.06.2022	654321	7	11	...

Having this 3 tables I create another table from the "Deliveries (All)" Table where there are stored all suppliers with name and ID. This table looks the following, whereas blue values indicate calculated columns

Summary

Supplier ID	Supplier Name	Total delivered	Total rejected	Reject rate
10	Supplier A	15	4	26,66 %
11	Supplier B	12	7	58,33 %

To get the values I do the following: 

Total delivered = 
CALCULATE(
   SUM('Deliveries (All)'[Quantity Received], 
   ALLSELECTED('Deliveries (All)'), 
   VALUES('Deliveries (All)'[Supplier ID]
   )
)

Total rejected =
CALCULATE(
   SUM('Defects (All)'[Affected Quantity], 
   ALLSELECTED('Defects (All)'), 
   VALUES('Defects (All)'[Supplier ID]
   )
)

Reject Rate = 'Summary'[Total rejected] / 'Summary'[Total delivered]

Now I have the following connections made: 

Now, I've made up a bar chart with the Top 5 in Sum of deliveries, defects and the reject rate using the corresponding blue marked columns. To this page I added a slicer, which uses the Year from the hierarchy of 'Times (Mastertable)'[Calendar day]. As far as it  goes for the "Deliveries" table it seems to be fine the deliveries get updated and filtered by the slicer. Problem is: The bar chart for the "Reject rate" does not update according to the data in the table. For example: The reject rate for my highest supplier is somewhere ~30 % and the highest shown value in the bar chart is like < 10 %, while the slicers are blank (All is selected right?). And I do not know what to do, to get this one properly displaying and working. Even, selecting certain Years do not update any of the 3 charts at all, and I'm concerned somehow my given structure is not suitable to display what I want to. 

I hope someone can enlighten with a solution. 

Best regards,

Xiao