Forum Discussion
Zip Codes in Multiple Service Areas
Community ChampionNow that I've seen your data I would take a different approach. I can get this matrix, which to me seems not super informative, but it does correspond to the data you gave, as every zip has every market.
I created a model that looks like this. In Power Query I created a Zip Dim table that will control both the Zip sales and Market Fact tables.
If you need further help, can you let us know what your end goal is? I feel like I am doing a bit of guessing as to where you are going. In other words, "I have this data, how can I get this visual?" vs "I have this data, and need to do this to it" when "this" may not get you to your goal. Make sense?
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
Thank you for your patience. I attempted to be specific in my initial inquiry but now see that could be difficult to interpret.
Below are screenshots (I made a sample powerbi file, can't see how to attach here.)
Ultimately,
1. we want a table that compares each Market's totals from the initial data screenshot. So, totals from zip codes in two markets would subtotal in both markets.
2. We want a single slicer that can select each market on a report page, that'd be able to select Mkt_A or Mkt_B and receive the subtotals from either market.
In the last screenshot, you'll see the markets aren't mutually exclusive to each, and currently provided in a matrix format.
Does that make more sense? Thank you for your thoughtfullness!!!