Filter second table based on selected value in first table . No relationship exists between two tabl

Thank you in advance for your inputs I have two tables in my powerbi model , first which is the raw table and the second table which has items listed "Item"column from Table 1 is the slicer value w...

Need Help

v-eachen-msft
6 years ago
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.

filter_test.pbix43 KB

amitchandak

Super User

6 years ago

Jason6 , Option 1. Split the column in table 2.

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

Keep them diconncted and use in fllter clasue : https://docs.microsoft.com/en-us/dax/containsstring-function-dax

Jason6

Helper I

6 years ago

amitchandak I tried this and in my actual data i got 27 columns for one record, the value might keep increasing with future files , however even after i do that i would still need to filter based on selected value of table 1 filter

Forum Discussion

Filter second table based on selected value in first table . No relationship exists between two tabl