cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tbmauricio
New Member

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.

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Ross73312 Community Champion
Community Champion

Re: 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.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


View solution in original post

7 REPLIES 7
Ross73312 Community Champion
Community Champion

Re: Extracting a filtered number

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

 


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


tbmauricio
New Member

Re: Extracting a filtered number

@Ross73312 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

Ross73312 Community Champion
Community Champion

Re: Extracting a filtered number

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/

 

 


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


Ross73312 Community Champion
Community Champion

Re: Extracting a filtered number

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


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


tbmauricio
New Member

Re: Extracting a filtered number

@Ross73312 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

Ross73312 Community Champion
Community Champion

Re: 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.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


View solution in original post

tbmauricio
New Member

Re: Extracting a filtered number

I was afraid about it =/

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors