Forum Discussion

tbmauricio's avatar
tbmauricio
New Member
9 years ago
Solved

Extracting a filtered number

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.

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

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

     

    • tbmauricio's avatar
      tbmauricio
      New Member
      9 years ago

      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's avatar
        Anonymous
        Not applicable
        9 years ago

        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/