I am trying to get two filtered tables, each with location data, to populate on the same map in Power BI. When I merge the tables into a third table, the filters from one table excludes the needed items in the other table. See attachment "data backend" for a visual representation of the connected tables.
This is a Direct Query, where I merged the mm dim_Sources table and the mm dim_Company table into mm view_City_Visits. But the filters on the mm dim_Company table are filtering out the items I need to see in mm dim_Sources. And if I don't apply the dim_Company filters, the map becomes unusable. See attachment "visual" for a snapshot of the visual without the active relationship between dim_Company and view_City_Visits.
I think this project would only take a couple of hours so hopefully this is a quick payment for anybody who knows how to do this. Thank you in advance for the help!
This job is already closed and no longer accepting applicants, sorry.