Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to 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
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
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
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