I'd like to see all schools in a state by school district. I have a spreadsheet of schools where School Type is used to identify whether the school is Public or Private. Each schools lat/long is also in this spreadsheet.
When I upload the spreadsheet into Power BI, and add the lat/long into the appropriate fields, I see all schools. But, if I filter by School District and also filter where School Type is private I get only those schools that are Private in the selected School District.
Instead I want all schools in a School District plus all those where the School Type is Private.
If you think in terms of a Venn Diagram, I want the area in both circles, not just the intersection of the circles.
How can I accomplish this?
