Filter table based on another table

Question

Just want to ask something. I have 2 tables in Powe BI. One contains a data set of 13 million rows and the other table contains one columb with the list of values I want to filter in the main table. I'm trying to create a filtered table containing only all the values in my 2nd table. Is it possible to filter based on the whole list of my 2nd table?

nirvana_moksh · Answer

Can you try this : Table = CALCULATETABLE('TABLE 1',EXCEPT(VALUES('TABLE 1'[ID]),VALUES(TABLE 2 [ID])))

nirvana_moksh · Answer

FYI you can also do this at the Power Query level, by doing a Merge as New and using Inner Join&nbsp;

anonymous · Answer

Go to &nbsp;Query Editor - &gt; Select Table 1-&gt;Home -&gt; Combine-&gt;Merge Queries-&gt; YOur Table1 will appear default, Select Table 2, Select the joining column, Select the join Type as inner join.&nbsp;You should be able to get lots of example in internet. Check the 'Combine Data ' section in this link.&nbsp; Its just straight forward.&nbsp;https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data&nbsp;ThanksRaj

justin22pogi · Answer

I'll try doing the calculate table. But why do we need to use EXCEPT?For the Power Query using Merge as New and Inner Join, do you have a link on the guide on how to donit?Thanks for the reply?

anonymous · Answer

If you filter in PowerQuery, then you avoid loading all the "useless" date to the model.

Forum Discussion

Filter table based on another table

8 Replies

Related content

Filtered table

FILTER TABLE BASED ON ANOTHER TABLE

Filter table using another table result

Conditionally filtering rows from a table with another table

DAX Filter A Table by Another Table