Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
abdalla
Helper I
Helper I

table data not showing properly

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.

abdalla_0-1658299171630.png

distance measure 

abdalla_1-1658299197176.png

maximum distance measure 

abdalla_2-1658299224383.png

If any more information is required I would be glad to provide them immediately

1 REPLY 1
lbendlin
Super User
Super User

Use the Haversine formula instead of the Great Circle formula.  Haversine works better for small distances.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors