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
Sorry, this is not quite it unless there's another step I can't figure out. We'd need the Market A, B, and C markets to then only display the totals for the zip codes that are within their market.
I re-articulated my request in another reply but my previous statement is the end-goal "This" your asking for, I hope that makes sense.
I appreciate your assistance.