Creating a new table using existing tables

You generally want to do this in Power Query, which is designed for data modeling. This article by Microsoft will explain how. It uses Power Query in Excel, but it is identical to how Power Query in Power BI works.

If you still need help Anonymous please post some data via the methods in the links below so we can assist.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum

hi Anonymous 

Table 1 and Table 2 join on name, Table 2 and Table 3 join on Email.

Just set cross filter direction is "Both" for these two relationship, then Table 3 can filter Table 1

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships#cross-filter-direction

Regards,

Lin