How to filter dates in one table based on selections from other

[Anonymous]

Hi PowerBi Community,

I have a many tables and relationships, but to summarize my problem - 

Table A

Object	Date	Ct
A	1-Jan	5
A	3-Jan	10
A	5-Jan	15
B	2-Jan	1
B	5-Jan	2
B	7-Jan	3

Table B

Object	Date	Status
A	1-Jan	1
A	2-Jan	1
A	3-Jan	0
A	4-Jan	0
A	5-Jan	1
B	2-Jan	1
B	3-Jan	1
B	4-Jan	1
B	5-Jan	1
B	6-Jan	0
B	7-Jan	0

the dates here will always

- be on a daily level

- have the start and end date according to the min and max date in table A according to each object

Table A and B have a relationship based on object column -

I have two visualizations, for table A and B, and the goal for me is to ensure both display for the same timeperiod.

NOTE: there are a few other slicers on the visual as well, which I would like to keep as is.

I have tried a few different approaches but none of them have worked out for me 😞 

- I have tried to add an intermediate date dimension table. This filters the both visuals on the correct dates, but then I am not able to pull the count of status for the correct objects.

- I have tried to use SELECTEDVALUES, VALUES, ALLEXCEPT but none of them have yielded correct results for me.

Any help with this is much appreciated! Thank you in advance!

[Greg_Deckler]

@Anonymous Are those tables related and if so on what column?

[Anonymous]

@Greg_Deckler , they are related on the Object column