Sum Value in two different table based on a single date filter

hi Anonymous 

If there is a relationship that between table1 and table2? If yes, you couldn't create two relationship between date table and table1/table2 at the same time, since it will lead to circular dependencies problem, for example:

If you have create a relationship between table1 and date table.

when you filter a date table, then it will filter table1, now table1 will filter table2 too. But you want to create another relationship between table2 and date table, now date table will filter table2 and table will filter table1, this is a circular dependency.

Regards,

Lin