Date table not filtering an indirectly connected table

[Rishabh-Maini]

Hi,

I have a model which is using a Date table and 3 other tables.

Table 1: Dimension 

Table 2 and 3: Fact

The relationships are defined as:

The issue here is that I have to build a matrix using Table 2 and 3, but the date table is not filtering out the matrix. (See below)

There is no Date column in the dimension table, and I cannot connect Table 3 with the date table with an active relationship. (Since date table is already connected with Table 2 ) see below:

Any suggestions on how to get the table 3 filtered with the date table?

I'm also attaching the above file with this question. 

https://drive.google.com/file/d/1o2TnhSE8BPOZGYC7lL-7cWLxT5he0ByA/view?usp=share_link

[amitchandak]

@Rishabh-Maini , Ideally there should not be any join between table 1 and table 3

Join table 3 with date, If need add additional dimensions to connect with tables to analyze the data together

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...