Forum Discussion
Extracting a filtered number
Columns are calculated on Data import, not at run-time. So you won't be able to create or update a column on the fly with user filters. Measures are your only option.
Is this table simply going to be held in memory as part of another Dax statement, are you hoping to use this as a parameter for another report or are you hoping to build a table that will appear on your table/field listing on the right?
If you want to use it within another DAX statement, thats pretty easy. Set up a measure that takes the MIN of your Latitude column. Once filtered it will only have 1 row, those get you the value you want. Then you can start your DAX statement with
Your Measure = VAR InputLat = [LatInputMeasure] RETURN
If you are wanting to pass the value across to another report, have a visual that relies on a measure the produces a HTTP string you can click on. This string builds the parameter so when they click on the value it takes you to the destination report with the filters included.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-url-filters/
Lastly, a measure can't be used to create a saved data table. It can help you filter a matrix or something display.