Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 other point on the scatterplot? I'm trying to use something as follows, but to return the minimum sqrt:
Distance =
var x1 = SELECTEDVALUE(Locations[X])
var x2 = values(Locations[X])
var y1 = SELECTEDVALUE(Locations[Y])
var y2 = values(Locations[Y])
var result =
sqrt(power((x2-x1),2)+power((y2-y1),2))
return
result
Solved! Go to Solution.
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])
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])
Thank you, Greg. This definitely works!
The only tweak I'd need is that I can't exclude points that match the selected X or Y. Any way to just remove the given point and not all related x/y values?
Perfect. Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |