By using the new trigonometric DAX functions available in Power BI desktop, straight-line distance on the Earth can be calculated. The new DAX variable feature also comes in handy in constructing this useful formula.
See: https://dhexcel1.wordpress.com/2015/08/16/measuring-distance-in-power-bi-desktop/
Hope that you find this useful!
See: https://dhexcel1.wordpress.com/2015/08/16/measuring-distance-in-power-bi-desktop/
Hope that you find this useful!