Forum Discussion
2 relationships between 2 fact tables
2 relationships marked in green
Hi. I need 2 relationships between 2 tables. (Sales Table, Budget Table) One Relationship is to connect the customer nr. The other is to connect the dates.
I can activate only one relationship at the time. Its quite frustrating.
u can't activate link between dates and Budged because u should use only one way to filtering tables
for example, filter Sales cube 2 way dates->sales cube and dates->budget->customer->Sales cube
use one direction link between customer and Budget tables
or use dax function USERELATIONSHIP() when u create a measure
ps sorry for my eng
4 Replies
- petrovnikitamai
Resolver V
u can't activate link between dates and Budged because u should use only one way to filtering tables
for example, filter Sales cube 2 way dates->sales cube and dates->budget->customer->Sales cube
use one direction link between customer and Budget tables
or use dax function USERELATIONSHIP() when u create a measure
ps sorry for my eng
thank you. now the relationships are active. But only the budgets of the customers, that also have sales, appear in the report.
Should be solvable somehow. I know that if I could make the highlighted relationship bi directional, it would work. But I can't because of the Date Relationship. Do you have an idea?
- petrovnikitamai
in pivot tables in report use column Customer from Customer table, not from Budget or Sales