Forum Discussion
multiple fact table
Hi everyone, I'm still learning Power BI and the data warehouse concepts, I have a problem with a scheme with multiple fact tables. I have to create different dashboards that represent simultaneous...
In your scenario, your Accounting dimension has two path to the Payroll fact table. One via Time dimension, the other via Office dimension. This makes the circular relationships. So you need to make either the relationship to Time dimension or Office dimension "inactive".
Regards,
Hi, thank you for the answer but in doing so I would lose the ability to filter the data. I can not create a single fact table (the data are completely different for granularity and for specificity of the data itself). What is the best solution? Create a Crossjoin table from the dimensions and place it at the center of the diagram, tying the fact tables to this new table?
