Relationship between tables

[Anonymous]

Hi, 

I'm having some trouble creating a relationship between 3 tables, which are all related by the column 'metric'. I'd love to link them all so i can then filter/slice by the 'Metric' - Each table has the metrics - PTAT, PEOPLE REACHED & PAGE LIKES 

Anyone able to help?

Thank you!

Sonia

[Phil_Seamark]

HI @Anonymous

Does one of the three tables only have unique values for METRIC in it?

[Anonymous]

Hi Richard, 

No, they've all got the same three (but different values for each metric) which i think could be the problem! 

Is there any way around this?

[Phil_Seamark]

Maybe create a new table that has every METRIC value

[Phil_Seamark · Accepted solution]

This DAX might help create a table that you can then relate your three existing tables to

Table = 
    DISTINCT(
        UNION(
            VALUES('Demo'[METRIC]) ,
            VALUES('Country'[METRIC]) ,
            VALUES('City'[METRIC]) 
            )
      )

[Anonymous]

Hi Phil, 

That worked! 

Thank you so much 🙂 

Sonia

[Anonymous]

Hi @Phil_Seamark

Thanks again for this great tip, I've been using it a lot!

Unfortunately, for this latest one, I'm getting a null value in the new table, but I can't work out why... 

Any ideas?

Account Relationship =
DISTINCT(
UNION(
VALUES('HOMEPAGE'[SITE SECTION]) ,
VALUES('HOMEPAGE+FRANCHISE'[SITE SECTION]) ,
VALUES('MARVEL'[SITE SECTION]),values('OTHERS'[SITE SECTION]),values('PIXAR'[SITE SECTION]),values('SHOP ALL'[SITE SECTION]),values('STAR WARS'[SITE SECTION])
)
)

Then in my new Table it returns

HOMEPAGE

HOMEPAGE+FRANCHISE

MARVEL

OTHERS

PIXAR

SHOP ALL

STAR WARS

Thanks again

Sonia