Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |