Recreate INNER JOIN behavior - Show only data that exists in both tables

[admin-unidoze]

I struggle already a long time solving this, and in the past I always found a way to get around the problem, but not this time 🙂 :

If I have a table Table1 with 6 key/value records:

PID    Name

1       Value1

2       Value2

3       Value3

4       Value4

5       Value5

6       Value6

And I have a Table2 that has a foreign key to Table1:

PID    Something1    AnotherThing    Table1_FID

1        Blahblah1        BlihBlih1             4

2        Blahblah2        BlihBlih2             5

3        Blahblah3        BlihBlih3             1

4        Blahblah4        BlihBlih4             4

If I want to show an easy filter on my dashboard with the values from Table1, but only for those that have a reference in Table2: I don't know how to do it. (And let's just say I add a Card to show the number of records that exist in Table2, when you change the filter).
So I want a filter control, only showing "Value 1", ,"Value 4" and "Value 5".

In the past, I prepared the data of the two tables in one big table in SQL Server, by just joining them with an INNER JOIN, and I had the value-column of Table1 existing in that big table. When I create a filter on that specific column, I only see the records that are explicitly used, as intended:

PID    Something1    AnotherThing    Table1_Value

1        Blahblah1        BlihBlih1             Value4

2        Blahblah2        BlihBlih2             Value5

3        Blahblah3        BlihBlih3             Value1

4        Blahblah4        BlihBlih4             Value4

But since I'm using tables now from a non-SQL Server source (Dynamics 365), I don't have that possibility anymore, unless I create a new Power BI Table and join both tables. I'm not very fond of that idea, since my dashboard is based on a lot of data and data is duplicated in the pbix when I create a Power BI table, making the file twice as big (and larger than 1 GB). Otherwise the processing of joining those tables is done on client side what sometimes gives problems with slower computers.

Another solution is to recreate Table1 only for those values that exist in Table2, with creating a new table and using a LOOKUPVALUE, like described here by @Greg_Deckler : https://community.fabric.microsoft.com/t5/Desktop/Table-Relationships-show-only-data-in-both-tables/...

But I have more than twenty of those key/value tables with some of them being rather large, so I can't believe that this is the perfect solution.

So my question is: How can I make the relation between Table1 and Table2 as if it's an INNER JOIN-relation and not an OUTER JOIN, without creating extra tables?
Or can someone confirm that that those extra tables are the only way?

[admin-unidoze · Accepted solution]

So for those interested, this is the way I do it now:
I create a new column in my Table2-fields:

Table1Name = LOOKUPVALUE('Table1'[Name],'Table1'[ID],Table2[Table1_FID])

But in my opinion, it might also be possible by playing around with the relationships, like you would do in SQL.