Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Relationship between tables

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

 

 

 

Capture12.PNG

1 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]) 
            )
      )

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

6 REPLIES 6
Phil_Seamark
Employee
Employee

HI @Anonymous

 

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


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Anonymous
Not applicable

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?

Maybe create a new table that has every METRIC value


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

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]) 
            )
      )

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Anonymous
Not applicable

Hi Phil, 

 

That worked! 

 

Thank you so much 🙂 

 

Sonia

Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.