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?
Go to Solution.
This DAX might help create a table that you can then relate your three existing tables to
Proud to be a Datanaut!
Does one of the three tables only have unique values for METRIC in it?
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
Thank you so much
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...
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
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!