Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    7 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()
    )

     

    PBIX file: https://1drv.ms/f/s!AoQIGRpzoxRH0y64D4Ue5nYGNGbj