Creating the Correct Relationship/filter

Hi

I am connecting to a SQL table, the structure of which looks like (root_title column has my Farm names):

I have also created a view which counts each House1, House2, House3, etc. entry and consolidates it into one 'House' Column alongside a new 'Count' Column:

I have hooked both up to PowerBI and am linking them together via the Status column. In this example, I have created a clustered column chart based on the original SQL table:

And a Funnel Chart based on the View:

With the intention being that when I click on each house, it highlights where the red check (problem!) occurred but for each House, it highlights all of the red checks, which is not what I expect to see, so I have obviously done something wrong here.

I have consolidated all the houses into 1 column so that when i filter by "Root_title" (Farm) it dynamically shows me how many houses that particular farm has, so that I don't have to create 50+ reports for each individual farm.

Apologies in advance if I have not been very clear...and also thanks in advance!
Dan