Forum Discussion
Map with Multiple Relationships
Hello everyone, I am a recent user of Power BI and I need some help with this case. I am working with two tables. First one contains three columns: Origin, Destination, Issue (can have repe...
There's possibly a more elegant solution but a simple solution would be to add two calculated columns in the first table for Origin Longitude and Origin Latitude and then use those in your second map.
Calc would be something like
Calculate( Values( Tabe2[Longitude]), Filter(Table2, Table2[Location] = Table1[Origin]))
Calculate( Values( Tabe2[Latitude]), Filter(Table2, Table2[Location] = Table1[Origin]))
Or for consistency add 4 columns, for origin long lat and destination long lat.
Hope this helps,
Will