Forum Discussion
Distance calculation by selecting two points from map
The title is self explanatory, so I want to calculate the distance between 2 points that I select from the map.
The answer should show in a cardboard, and if more than 2 points are selected, the Cardboard should show (Blank).
What I have in hand:
1- Coordinates of all my points (Lat,Long).
2- The formula to calculate the distance between 2 points using coordinates.
The distance is the straight line between the two points, not a driving distance or anything special.
Question 2 (less important): it is possible to draw a circle with a certain radius around each point I select?
NOTE: ARCGIS or NORMAL Powerbi MAP allowed!
Anonymous I think it could be done if you did a couple checks -
Distance Measure = IF( COUNTROWS(LatLongTable) = 2,
VAR _LatA = Min(Lat)
VAR _LongA = Min(Long)
VAR _LatB = Max(Lat)
VAR _LongB = Max(Long)
RETURN
[DistCalc]
)
I don't know how your table is formatted, but you will need to be more precise with the Min/max lat and long to make sure they actually correspond to each data point, and that you don't use lat from one and long from the other.
Drawing the circle of radius I have met someone who I think said they achieved this, but I don't recall how....
4 Replies
Anonymous I think it could be done if you did a couple checks -
Distance Measure = IF( COUNTROWS(LatLongTable) = 2,
VAR _LatA = Min(Lat)
VAR _LongA = Min(Long)
VAR _LatB = Max(Lat)
VAR _LongB = Max(Long)
RETURN
[DistCalc]
)
I don't know how your table is formatted, but you will need to be more precise with the Min/max lat and long to make sure they actually correspond to each data point, and that you don't use lat from one and long from the other.
Drawing the circle of radius I have met someone who I think said they achieved this, but I don't recall how....
