Forum Discussion

manojsv16's avatar
manojsv16
Helper II
7 years ago
Solved

Relationship between Fact to Fact tables

Hello All,   I am working on to develop a report which has 3 fact tables and multiple dimension tables. Please refer the below screenshot for relationship layout of tables.  I wanted to connect fac...
  • d_gosbell's avatar
    7 years ago

    It's usually better to avoid fact to fact joins. If fact_1 and fact_2 are logically related 1 to 1 this means you could inner join them and just create one large "virutal" fact table.

     

    For fact_3 if it is actually a 1 to many relationship what you could do would be to use the join column to copy all the dimension keys from the other two facts down to fact_3 then you would just join the dimensions to the facts and remove the join between fact_3 and the other fact tables. Then any time you filter on one of the dimensions both facts would get filtered.  

  • Anonymous's avatar
    Anonymous
    7 years ago

    google "power bi multiple fact tables" there are several videos on how to easily do this.  We ended up creating a linktable and two fact tables which works good.