Forum Discussion
Anonymous
7 years agoNot applicable
Filtering one table from another table's Selected Value
Hey Everyone! So what I'm trying to do right now is filter one table based on the selectedValue of another table. The tables are much more expansive than this in terms of content and columns fo...
- Anonymous7 years ago
Here's what I came up with. PBIX file is attached below.
Used Power Query to parse out the #'s from your table 2, since that is what will be searched for based on the user selection from table 1. Too much to list out here and much easier to see step by step in PQ. But the final table:
You were on the right track with the selected value, so stuck with that:
Col 1 Selected Value = SELECTEDVALUE(Table1[Column1],0)
I used that value and searched in our newly created "Just Numbers" column from above:
Contains = SEARCH( [Col 1 Selected Value], MAX(Table2[Just Numbers]),,BLANK() )
v-piga-msft
7 years agoResident Rockstar
Hi Anonymous,
By my tests, the solution of Nick_M should be your desired output.
If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry