Extracting a filtered number

[tbmauricio]

Hello everyone,

I have one doubt about using a filtered data.

For example, I have a table with a lot of sites names and latitudes and longitudes related to those sites.

I selected one data (CTA009B1) that has one latitude (in this case -25,52) and one longitude linked with it.

I would like to use this filtered latitude as an input to calculate another table. How could I do that?

I thank you in advance.

[Anonymous]

What do you mean by Calculating another table?  Understanding your intentions will guide us on how we can provide some advice.

[tbmauricio]

@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

[Anonymous]

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/

[tbmauricio]

@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

[Anonymous · Accepted solution]

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.

[tbmauricio]

I was afraid about it =/

[Anonymous]

Lastly, a measure can't be used to create a saved data table.  It can help you filter a matrix or something display.