2 relationships between 2 fact tables

[Anonymous]

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.

[petrovnikitamai · Accepted solution]

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

[Anonymous]

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

[Anonymous]

thx alot. It works now as intended. now one more question: 

If I want to use another dimesion from the sales table, for example customer group,  it won't slice the budget.

do I have to make a new table with this dimensions and connect it to the customer table or how can I do that best?