Forum Discussion
Best Way for work with Multiple Fact Tables
Hi everybody!! which is the best technique for working with models that have multiple fact tables and so get a star schema?. For example, in QlikView there is a technique called "linktable". ...
Power Bi allows you to use several fact tables in the same analysis (even with different granualities such as budget vs actual sales) as long as you have common dimension tables. Do not try to link the fact tables directly.
DAX will calculate the measures against the common dimensions and then let you compare the results for the different fact tables in the same analysis
Have a look at this link
http://www.powerpivotpro.com/2012/01/salesbudget-integrating-data-of-different-grains/
I agree, most of your measures will naturally fit a specific Fact table and there will be little benefit to linking Fact tables for most measures.
However you can still create a Measure on FactA that references a calculated measure on FactB if required