Forum Discussion
Solved
Calculating minimum distance between XY coordinates
I'm trying to determine the closest point to any given point on an XY scatterplot. For simplicity, data is plotted on a 10x10 XY axis. How can I calculate the minimum distance from each point to any ...
Probably something like:
Distance = VAR x1 = SELECTEDVALUE(Locations[X]) VAR y1 = SELECTEDVALUE(Locations[Y]) VAR __Table = ADDCOLUMNS( FILTER(ALL(Locations),[X] <> x1 && [Y] <> y1) "distance",SQRT(POWER(([X] - x1),2) + POWER(([Y] - y1),2)) RETURN MINX(__Table,[distance])- Well, that's what I was trying to do with that filter. You would need some kind of ID or Index. So if you had that identifier, just grab the identifier with a SELECTEDVALUE and then filter on that identifier <> that.
Greg_Deckler
Community Champion
Community ChampionWell, that's what I was trying to do with that filter. You would need some kind of ID or Index. So if you had that identifier, just grab the identifier with a SELECTEDVALUE and then filter on that identifier <> that.
Perfect. Thanks!