The Dax code is
VAR Final_Table =
Crossjoin_Table, // crossjoin of Suburb, Lat, Long and Store, Lat,Long
"Sub_Name", 'Sub Heirarchy'[Name],
"Store_Name", 'Retailers Table'[Store Name],
"Sub-Store Dist", [Dist] // a calculation of distance between Suburbs and Stores... 4.3M values.
However, I've tried every possible permutation and combination of dax expressions to filter the distance values of the Sub-Store Dist field without success. The major issue being the Field is not available for use in a Calculate or Calculatetable statement and only appears in the following code,