Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Data Model/Relationships with 4++ Fact Tables

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

 

Need Help

1 Reply

  • some_bih's avatar
    some_bih
    Community Champion
    3 years ago

    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.