Matching column values from one table to another

[Anonymous]

Hi,

I have two tables

Table 1 headers = Email, Pageviews

Table 2 headers = Email, Country

I am seeking a way to match the emails together so that essential I can be able to filter by country to see the pageviews for the emails within that country.

I tried in the data model to build a relationship but one of the columns has to have unique values and I'm not sure if this is the solution anyway.

If anyone has any ideas, that would be great.

Alex

[RohithGn · Accepted solution]

Hi,

You could create a new Dim table with distinct values from either Table 1 or Table to then set the relationship with this unique emails to both the tables. 

Table 3 = DISTINCT(Table1[Email])

Regards,

Rohith

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may update your desktop and try to use many to many relationships. Here is the documnet for your reference.

Many-to-many relationships in Power BI Desktop (preview)

Regards,

Cherie

[RohithGn · Accepted solution]

Hi,

You could create a new Dim table with distinct values from either Table 1 or Table to then set the relationship with this unique emails to both the tables. 

Table 3 = DISTINCT(Table1[Email])

Regards,

Rohith