Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Matching column values from one table to another

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

Need Help

2 Replies

  • RohithGn's avatar
    RohithGn
    Helper I
    7 years ago

    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