#Power point measure distance code

If you were thinking of a calc column, why SELECTEDVALUE ( 'Route Information' ) instead of simply 'Route Information'?Ĭ) Is the CALCULATE after the return necessary? I guess it's just the remnants of the first approach whose very last line you commented out? If it's so, I would take it out. Were you thinking of a measure? I'm asking because you are using SELECTEDVALUE( ) in the definition of _ThisHOUSE. Just to double check: Are you sure the formula to calculate the distance between to points (Harversine) is working correctly and not the curious about your approach and have a couple of questions:Ī) Why are you using two nested MINXs? Wouldn't only one suffice, like in the initial example? I'm probably missing something.ī) I understand needs a calculated column. Hope you don't mind my partaking in what sounds like an interesting you share the pbix or at least a fragment of it with a data sample that can be used for testing? So on the bottom map we are just seeing A05400 and R15700 then the top map is all the houses available in that area, highlighting in red what it classed as closest?Īlso in the table we can see it thinks R15700 closest house is S55000 which just adds more mystery but is slightly plausable if S55000 was further north but still S55000 isn't the closest to R15700 anyway.īeen stairing at this for days now and you've already got better results than me just need to be able to rely on it So in this exmaple we can see it saying closest store to A05400 is 145.6 miles and that house ref is R15700. Now its returning the odd few, stradorically but not sure on the validity of the closest house as i can see with some filters its a bit random. Now this formula before just returned every MEMNO the same as the MEMNO we were looking up the closest value for, which was expected as before the distance was Zero. So along with the Closest House (Miles) columns now using the formula you provided below i have this Closest House column which is returning the refference for this closest point so there is some usable context Ĭlosest House = CALCULATE(MAX('Route Information (Dup'')'), Not sure on whether its accurate though in its calculation

Okdokie we are making some progress no 0 values like before, thanks Dedelman! Basically I added the MAX at the top, removed the duplicate table, and moved the filter into each call to 'Route Information', and wrapped ALL() around the table so it will iterate over the entire table regardless of which point is selected. I tested on some Lat-Long data that I had and it definitely changes values (that are not 0) when I click on a spot on a map (I can't vouch for the formula's accuracy, but at least it changes). 'Route Information' _ThisHOUSE //moving this up to the table on MINX and adding ALL * SIN ( ( ClostestHOUSELongitude - HOUSELongitude ) * P2 ) ^ 2 SIN ( ( ClostestHOUSELatitude - HOUSELatitude ) * P2 ) ^ 2 VAR ClostestHOUSELongitude = 'Route Information' VAR ClostestHOUSELatitude = 'Route Information' SELECTEDVALUE ( 'Route Information' )įILTER(ALL('Route Information'), 'Route Information' _ThisHOUSE), //Note the use of FILTER VAR HOUSELongitude = MAX('Route Information') VAR HOUSELatitude = MAX('Route Information') You should be able to do the calculation against a single instance of 'Route Information'.

IF ( _DistanceFromCurrentRough 0, _DistanceFromCurrentRough )Īs you can see, on 1/18/18, the distance is different for M49418 VAR CinemaLongitude = 'Route Information'Ĩ0 * SQRT ( POWER ( ( HouseLatitude - CinemaLatitude ), 2 ) + POWER ( ( HouseLongitude - CinemaLongitude ), 2 ) First, I recreated 'Route Information' to have 5 dates' worth of data, one date of which is missing 3 of the locations (Dt is literally just a list of 5 dates 1/14 - 1/18):

#Power point measure distance code

OK, I took code last post and turned it into a measure.