Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
im working on a business which my have more than 15 fact tables and a lot of dimension.So, im trying to have one shema in power bi trying to cover all the business needs by using common dimensions linking these facts together but I end up with a logic that im obliged to enbale cross filtering acrross many relations between fact and dimensions to let the data flows sommothly between different direction.is this healthy ?
thank you for your support.
I would critically asses how you build your fact tables. Maybe you have to redesign them.
For example: If you want to show the Actuals (first fact table), but only for those items how have also Bugdeted amounts (second fact table), then you would write a measure that determines the correct amount. But not create a (filtering) relationship from the budget table to the actuals.
Are you able to give one example of why one fact table in your model should filter another one?
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hello @ImkeF ,
your help is really apreciated.
Im sure also that this is not the right path to follow but what is the best way to follow when having many fact tables which may be linked one to many or many to many relationships with huge number of diensions that may be shared across different fact tables and i want to report the whole business kpis in one dashboared!
Hi @ahmadibrahimbus ,
that doesn't sound good to me. Crossfiltering between Dimensions is a common pattern, but why would one fact table filter another one via a shared dimension?
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |