The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I'm doing a table that displays the name and distance from a selected point.
My method used is i set a max distance that is chosen by the user and then the measure i created calculates the distance of all the other points around it and return their names if they are less than or equal to the value set by the maximum distance but my problem is that some points dont show under a certain distance when the max distance is set to 1.5, even though they show on the map i provided the measures and the tables pictures below, I would appreciate if someone can help me on resolving this issue.
All thanks and gratitude to this community that allowed me to advance in various ways.
Thank you.
Regards.
distance measure
maximum distance measure
If any more information is required I would be glad to provide them immediately
Use the Haversine formula instead of the Great Circle formula. Haversine works better for small distances.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
4 | |
4 | |
3 | |
2 | |
2 |