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 all,
I have three fact tables - Case Listing, Job Listing and JoBGRA Listing. All these have a column called Postal Code.
There is a dimension table Dim Zones with Postal code and additional attributes.
1. Case Listing --> Dim Zones on Postal Code --> Many to 1 relationship SIngle Cross filter direction.
2. Job Listing -- > Dim Zones on Postal Code --> Many to 1 relationship SIngle Cross filter direction.
Both are active.
3. Job GRA Listing -- > Dim Zones on Postal Code --> Many to 1 relationship SIngle Cross filter direction.
When trying to activate the third relationship get error message
The 3 tables do not have any relationship between them.
Unable to understand the reason for the error.
Appreciate any help.
Cheers
CheenuSing
Solved! Go to Solution.
At a glance it looks like the relationship between Dim Executives and Job GRA Listing may be contrinbuting to the problem.
Can you change this relationship direction so Dim Executives filters Job GRA Listing?
Hi @OwenAuger ,
Any pointers for this.
Best Regards
CheenuSIng
Hello @CheenuSing ,
because you have cross filter relationships, can you show us all the schema?
Proud to be a Super User! | |
Hi All,
Just to add I have active relationship of the 3 tables on column executives with Dim Executives table.
And it is perfectly working.
Cheers
CheenuSing
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 |
---|---|
97 | |
95 | |
76 | |
72 | |
65 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |