Data Model/Relationships with 4++ Fact Tables

[Anonymous]

Dear experts,

I have been dealing with this issue for 2 weeks already. I want to make relationship between 4 fact tables. So what i did was:

1) Combine all fact tables in one table

2) Remove other column except few columns to combine them to be unique ID

3) Since there is no unique id, i combine 3 column to be one column (Unique ID) & remove duplicate value

4) Merge the other table with new table that has unique ID to be one to many relationship

But when i try to display a table with all value from all fact tables, this error popped out.

Really confused is the error bcs of the incorrect data model? is it correct on how i create the unique ID?

Reallyy reallyyy need your help on this, your help is greatly appreciated.

Thanks. 

Regards,

Zety

[some_bih]

Hi @Anonymous  according  to your picture, you are trying to create 2 or more relationship for same table and this is not possible in PowerBI (only one column). Does this make sense to you? I hope this help.