Forum Discussion
Helper IFilter second table based on selected value in first table . No relationship exists between two tabl
Hi Jason6 ,
You could edit your second table in query editor. Here is my sample data.
1. Split "Column1" by delimiter.
2. Unpivot your category columns and remove extra columns. Now you could create relationships between two tables.
Then you could use SELECTEDVALUE() function to get a result as a flag in filter pane.
Here is my test file four your reference.
Community ChampionJason6 - You should be able to create a selector to do this for you. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
Basically, you can grab the value in the slicer using SELECTEDVALUE or MAX/MIN, etc. You can then use that to determine if the row in your second table matches that value and if so return 1, otherwise 0. You can filter the visual on 1.
Helper IGreg_Deckler In the file you shared, the Complex selector looks at a number and the measure is set accordingly based on single value
However in my example i have category labels and i have to use Search or find functionality to search in the second table
How can i encorporate the search feature and then set a measure