Dynamic filtering based on Slicer selection

[Naash]

Hello,

I have a query on filtering data using Measure, 

Scenario - I have two slicers one helps me filter the Location coordinates and the other(manually generated value, has no relation with other data) helps in selecting a range (10 yards, 20 yards).  I want to know is it possible to link and use these values to identify list of other coordinates that fall within a specific range of the selected value ?

So whenever a user selects a specific coordinate and range i want to display the list of data and their coordinates that is within that range. Can this be done ? 

[Aburar_123 · Accepted solution]

Please find the below solution,

1. Created a table

2. Create another table as below,

3. Create a measure as below,

Records in Yards range =

var min_yard = MIN('Table_Yards_slicer'[Yards])

var max_yard = MAX('Table_Yards_slicer'[Yards])

var is_in_range = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Yards]>=min_yard && 'Table'[Yards]<=max_yard))

return if(is_in_range>0,1,0)

4. Place the above created measure into visual level filter,

5. Yards slicer should be from 'Table_Yards_slicer' table.

if you follow the above approach you can solve your issue.