Visual shows non-related data

[Coo]

I have 2 visuals that I want it to show correlated data when date is selected. It works perfectly when correlated records can be found in both tables. However, it appears to be table on the right will show records of the earliest date when correlated records cannot be found. Is there a way to hide or force Visual on the right to not render non-related data?

The table on the right contains much less data than the table on the left. I created a measure field on both tables as a key to join both tables which is "agentid + calldate"

[CoreyP]

By "unrelated data" do you mean the blank row in the unavailable code column in the right table?

[Coo]

Sorry No. What I mean is that the left table is showing data from Sep 1st but the table on the right is showing data from Sep 11th because that's earliest date the right table has data. If I pick Sep 11th as the date, then both tables will show correlated data.

[CoreyP]

Can you share a screenshot of your model view with relationships?

[Coo]

sure. Thanks for looking

[CoreyP · Accepted solution]

I would recommend not using a many-many relationship unless you absolutely have to. Try creating a bridge table with unique values to join the two tables. Also add a date table so you follow proper star schema modeling practices. In the meantime, you could try changing the filter direction of both to single so that AllCalls filters the CCCAgent table.