Forum Discussion
Distance calculation by selecting two points from map
- 5 years ago
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 , refer if these can help
https://community.powerbi.com/t5/Desktop/Distance-Calculation-in-Power-BI/td-p/206979
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).