Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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]) ) )
HI @Anonymous
Does one of the three tables only have unique values for METRIC in it?
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
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]) ) )
Hi Phil,
That worked!
Thank you so much 🙂
Sonia
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |