Forum Discussion
Modeling with 3 fact tables
As you can see I added few columns that you asked for, and these coulumns cover all three fact tables. Its just that you need to perform the aggregation appropriately
I am atttaching the pbix for your reference
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Thanks tharunkumarRTK I have relate employee and date dimension tables with with three fact tables already. Performing the aggregations is the issue without proper relationships among the fact tables. That's what I hoped to get help with. I have watched a couple of videos including the one you shared and the solution seems straightfoward but when I create the bridge tables, I'm still unable to aggregare across the different tables. I suspect that I'm not defining the bridge tables correctly and I would appreciate some input based on the sample I shared. Thanks!
As you might already know, Power BI best suits for start schema and relating two fact tables deveiates your modelling from start schema. This will make your dax measures complicated and can cause performance issues. I went through the pbix and could you share the expected result?
I will try to build the same and can share it with you
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
For some reason It's not allowing me to add a table. See if you can access this sample file on Google drive: https://docs.google.com/spreadsheets/d/1MAv9ibPjwUARPnNhwXAj4BgCs7wbABMJsynSve50Ooo/edit?usp=sharing
As you can see I added few columns that you asked for, and these coulumns cover all three fact tables. Its just that you need to perform the aggregation appropriately
I am atttaching the pbix for your reference
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
For some reason It's not allowing me to add a table. See if you can access this sample file on Google drive: https://docs.google.com/spreadsheets/d/1MAv9ibPjwUARPnNhwXAj4BgCs7wbABMJsynSve50Ooo/edit?usp=sharing
For some reason my replies are not coming through. I hope this gets posted. Here is a link for sample table that I would like to create: https://docs.google.com/spreadsheets/d/1MAv9ibPjwUARPnNhwXAj4BgCs7wbABMJsynSve50Ooo/edit?usp=sharing