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!
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
|
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