Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, for some reason I'm not able to create relationship between 3 tables.
1. 1st relationship between two tables. - company to company. Purpose is to filter the page with desidered companies.
2. 2nd relationship between table revenue and calendar. - date to date. Purpose is to filter the page with desired period.
I'm not able to make the second relationship active due to above error message.
Help in this regard is highly appreciated.
Solved! Go to Solution.
I suspect you might also have a bi directional many to many relationship between demographic and hist revenue. The four tables demographic, hist revenue, calendar and revenue would need to look like:
You would however be better to separate portfolio and company out into their own dimensions so you have a unique list of both which removes the many to many relationships.
Hi,
This is the relationship matrix amoung various tables.
The initial solution of single filtering is not working.
I suspect you might also have a bi directional many to many relationship between demographic and hist revenue. The four tables demographic, hist revenue, calendar and revenue would need to look like:
You would however be better to separate portfolio and company out into their own dimensions so you have a unique list of both which removes the many to many relationships.
Have a read of:
Can you send a screen shot of the rest of your data model? I suspect your date table is related to another table which in turn related demographic.
As an initial solution set the cross filter direction as single with demographic filtering revenue.
User | Count |
---|---|
94 | |
87 | |
79 | |
76 | |
69 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |