Forum Discussion
Map Visual query
Here is one way...(For this example, these are just random locations - no real data)
Basically you need the Zip codes in a single column (in my example, the lat/long coordinates). If you structure the data as follows
including the "Parent retail" column assigning both the retail outlet and the corrresponding customers to the same retail value, you can then get the following:
I've attached the sample PBIX file
ChrisPBIUser , I doubt you can use both, Also, I do not think it will allow you two measures, Otherwise you can use common tables and two measures. And one measure use userelationship.
Create two measure, Create calcultion group and then use that as legend
Single postcode table, join to both.
Two measures using userelationship
Then
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Cheers for the prompt reply. I'll take at look to see if it will do what I need, but as you stated at the start it looks like it will not allow two measures on the actual visual.