Combine 2 different tables and get intersecting rows

commonsenseuser you don't need 3rd table, just create a surrogate key by combining 3 columns in both the tables and set the relationship between these table on this new key, and from there you can use these into any visuals,  as a best practice, it would make sense to add 3 dimension tables like brand, customer type, and country and have a relationship of these 3 dimension tables with your table 1 and table 2, and from there everything will be super easy to analyze.

Hi commonsenseuser ,

Please do like this.

1. Create a calculated table.

Table 3 = 'Table 1'

2. Create a calculated column in 'Table 3'.

Brand Awareness = 
LOOKUPVALUE(
    'Table 2'[Brand Awareness],
    'Table 2'[Brand], 'Table 3'[Brand],
    'Table 2'[Customer Type], 'Table 3'[Customer Type],
    'Table 2'[Country], 'Table 3'[Country]
)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.