Distance calculation by selecting two points from map

[Anonymous]

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!

[AllisonKennedy · Accepted solution]

@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....

[Anonymous]

Excellent! Thank you so much! The logic works, now i need to figure out how to make the calculation work. Thank you again!

[amitchandak]

@Anonymous , refer if these can help

https://community.powerbi.com/t5/Desktop/Distance-Calculation-in-Power-BI/td-p/206979

https://stackoverflow.com/questions/27928/calculate-distance-between-two-latitude-longitude-points-haversine-formula

[Anonymous]

Indeed, I have seen those and that is why I said in my question that I know the formula. What I am asking for precisely is a way to do that by selecting those points on the map directly (if that is possible).