Multiple Fact Table In Model

[AlfredoBIS]

Hi guys,

I have multiple fact table in my model. How can I make relationship between them? I am so confused.

Thank you for your helps.

[mahenkj2]

Hi @AlfredoBIS,

Every main business process have multiple sub processess. That is natural/normal.

You need to carefully decide such sub processes. Each process will have fact table and multiple dimension tables. At some point, multiple processes need to be merged to get another picture of the process, for this aggregate tables are being used.

Its a whole set of concept, known as dimensional modelling. If you are doing some ad-hoc reporting, then may be fine to take short route to make quick reports, but if you are seriously considering going into it and would like to answer all of the questions of your report users, then may refer the below resources:

https://www.amazon.in/Data-Warehouse-Toolkit-Definitive-Dimensional/dp/B01ABXEKI8/ref=sr_1_3?keyword...

https://www.amazon.in/Schema-Complete-Reference-Christopher-Adamson/dp/0071744320/ref=sr_1_1?crid=2Y...

I described above items very much in brief...

[PC2790]

Hey @AlfredoBIS ,

I can see some of the fields common in all like Broker ID, Policy ID etc.

Can you consider creating a bridge table for that?

See if any of the below helps:

Handling MULTIPLE fact tables in Power BI - Guy in a Cube

Dealing with multiple fact tables | Power BI for Business Users (Beginners Welcome) (pbiusergroup.co...