Distance based on Bubble assigned by first location

[Chanleakna123]

Hi All, 

I would like to calculate the distance between the sales rep visiting customers, how many km sales rep traveled/day based on the outlet we have assigned. Sales rep will leave from the location where we assign and visit the customers.

From our side we would like to understand the distance of one sales rep visits the outlets, as what i did on google map below. the map below shows the distance 3.8km, starting from the location I have circled to other locations. Is PBI can perform such formula? 

in the report , we will show the total KM of Sales rep visiting their customers based on date filter. 

[v-xiaotang]

Hi @Chanleakna123 

Thanks for reaching out to us.

I doubt if it is possible to calculate distance in a map. For distance calculation, you need to create an auxiliary table with all the address information first. Here are 2 posts for your reference,

Calculate the Distance between Two Locations - Microsoft Power BI Community

Solved: Distance Calculation in Power BI - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Chanleakna123]

Hi @v-xiaotang  , sales rep will continually visit one outlet to another outlet within around the area . The assign location from warehouse and  outlets around the area will be calculated based on the distance from one to another . I can done this through google map as shown . Not sure whether PBI can calculate all the distance between 1 to another ? It can be an averages . 

[v-xiaotang · Accepted solution]

Hi @Chanleakna123 

Thanks for your reply.

>>Not sure whether PBI can calculate all the distance between 1 to another ? 

It is possible to achieve it if detailed data of all locations are provided as in this article below. The output can then be displayed in a table visual. If you want to display the output in a Map, you need to consider using tooltip. for example, when your mouse hovers over a location, the tooltip will show the distances to all related locations

Distance Calculation On Map | Power BI Geospatial Analysis - Enterprise DNA

Hope this helps!

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.