Creating the Correct Relationship/filter

[DJsummers]

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

[lbendlin · Accepted solution]

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523