Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Filters are always applied on top of each other ("AND") . You can only implement your "OR" scenario by using measures and flags.