How to keep the rows of one CSV/table based on common value in column in another CSV/table?

[tintinsherlock]

I did not know how to put my question properly in the Subject so I will elaborate. 

Suppose I have one table (imported through a CSV/TSV) which looks like this - 

ColumnA	ColumnB
1	Liz Lemon
2	Michael Scott
1	Chandler Bing
3	Ron Swanson
4	David Rose

I have another table (imported through a CSV/TSV) which has only one column

ColumnA

1

I want to show only those rows in the first table for which ColumnA values match the ColumnA values in the second table.

So the output I want is

ColumnA	ColumnB
1	Liz Lemon
1	Chandler Bing

I want to show this final output above inside a TABLE visual in the report. 
I have tried INNER JOIN-ing the two tables but the result somehow doesn't get reflected in the TABLE visual, which is what I need. 
Please help if possible.

[johnt75]

If the table with only 1 column has unique values then you can create a 1-to-many relationship between the tables and use ColumnA from the 1 side in your table visual along with ColumnB from the many side.

[MFelix]

Hi @tintinsherlock ,

Merge Table one with table two based on the column A, then select rigth outer:

https://docs.microsoft.com/en-us/power-query/merge-queries-overview

[tintinsherlock]

Thanks. I tried this and this worked.

[amitchandak]

@tintinsherlock , Create a measure and use that with the ungrouped column of a table 1 or use a visual level filter

measure =

countrows(filter( Table1, Table1[ColumnA] in values(Table2[ColumnA]) ) )

[tintinsherlock · Accepted solution]

I don't want to use a visual level filter as both the columns actually have a LOT of rows.