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.
Anonymous This latitude will be used as a variable in another table/column.
For example:
Column 1
120 - Var Latitude
100 - Var Latitude
50 - Var Latitude
1.000 - Var Latitude
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.
Anonymous You gave me a heads up. Part of the problem I can solve with your solution, but actually I want to use this MIN Latitude as a variable to calculate a new column
New Column
Latitude 1 - MIN Latitude
Latitude 2 - MIN Latitude
Latitude 3 - MIN Latitude
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.
I was afraid about it =/