Power Pivot 3 tables connection

[diagea]

Hi,
I want to connect 3 tables by Power Pivot and receive “Relationship may be needed?” .
1 with columns: Origin, total events
2 with columns: Origin, Deposits
3 with columns: Origin, total events
Relationships:
1. Second-Origin to First-Origin
2. Second-Origin to Third-Origin
Results:
By each Origin I have total events number(from table1), deposits number(from table2), and same value for all the origins (from table3).
Where is my mistake?
Thank you!

 

[scottsen]

Possible to share out the workbook?

 

[diagea]

No, I can't, thank you.

 

[Tianbas]

Without the workbook we can only guess. I think you have used the "wrong" origin in your pivot table. From what you describe the 2nd table is your fact sheet and you should use Origin from the second table as row or column in the pivot. Table 1 and 3 are just lookup tables. If you use Origin from table 1 or 3 you might get the relationship warning

 

[scottsen]

A picture of the diagram view would help as well.