Forum Discussion
Multiple fact tables for the same dimensions in tabular
Hi, im making a tabular model to use in Power BI and i have more than one fact table related, (Orders, sales, shippings) and all the tables are related to the Client, Items, Calendar dimensions but I...
Hi,
I am also facing the same issue with Mutliple facts and multiple dimensions.
Hi Praveen,
Fact tables should not be related together : dimension table are related to Fact tables. If you need to relate fact, then you should ask yourself : what is the exact need ? Could I create a new dimension to express the need, and then I will relate this new dimension to multiple fact tables, which is of course always possible (except if data is buggy). Does this help ?
Please look at the Microsoft GuyinACube video on multiple dimensions and multiple fact tables.