Forum Discussion
Anonymous
6 years agoNot applicable
Multiple active Relationships
I have three tables (Price Book, Quotes, Sales) with the following columns -- Part Number, Customer, and Rep. I then created two additional tables -- Master Part Number and Master Customer with the following equations.
Master Part Number = DISTINCT(UNION(SELECTCOLUMNS('Price Book',"Part",[Part Number]),SELECTCOLUMNS(Quotes,"Part",[Part Number]),SELECTCOLUMNS(Sales,"Part",[Part Number])))
Master Customer = DISTINCT(UNION(SELECTCOLUMNS('Price Book',"Customer Name",[Customer]),SELECTCOLUMNS(Quotes,"Customer Name",[Customer]),SELECTCOLUMNS(Sales,"Customer Name",[Customer])))
When I created the relationships between Master Part Number and the three other tables, everything works great. I can create a page wide filter, and data is shown from all three tables correctly.
However, when I add the relationships between the Master Customer and the three other tables and try make it active, I get the following message
and my data looks like this:
Is there a way to have both relationships active? I need the page to be able to sort by either customer or part number.
You relationships should look like the following (note the arrows)
Master Product 1 -> * Fact * <- 1 Master Customer
3 Replies
- Greg_DecklerCommunity Champion
You relationships should look like the following (note the arrows)
Master Product 1 -> * Fact * <- 1 Master Customer
- parry2kSuper User
Anonymous or share relationship diagram and where it is failing.
- AnonymousNot applicable
Thank you. I didn't notice that two of the arrows were the wrong way.