Forum Discussion
Solved
Dynamic filtering based on Slicer selection
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 ...
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.
Aburar_123
Solution Supplier
Solution SupplierPlease 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.