Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Can we have multiple Fact table in Data Model

Hi All, As per our requirement, we need to use three unrelated fact tables, basically different data models. We want to create three pages in our Power BI report, one page for each data model. Plea...
Need Help
  • belisqui's avatar
    belisqui
    7 years ago

    That's probably because of the cross filter direction - both. You need to ensure your relationships between Dim and Fact are not overlaping with relationships between Fact and Fact.

     

    In the example below I wouldn't be able to create an active relationship between occurences AND incidents (running) because there is already a link connecting Incident to Occurrence.

belisqui's avatar
belisqui
Advocate IV
7 years ago

That's probably because of the cross filter direction - both. You need to ensure your relationships between Dim and Fact are not overlaping with relationships between Fact and Fact.

 

In the example below I wouldn't be able to create an active relationship between occurences AND incidents (running) because there is already a link connecting Incident to Occurrence.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks belisqui 

Really appreciate your help.