Forum Discussion
Can we have multiple Fact table in Data Model
That's probably because of the cross filter direction - both. You need to ensure your relationships between Dim and Fact are not overlaping with relationships between Fact and Fact.
In the example below I wouldn't be able to create an active relationship between occurences AND incidents (running) because there is already a link connecting Incident to Occurrence.
That's completely fine. There is no issues with adding multiple unrelated fact tables to Power BI. You don't need to follow any formal methodology.
Ideally you may have a Date Dimension collecting them all, but they can be completely indepentent if you want.
Thumbs up if that answers your question.
I got some requirement that i needed to bypass a page level filter like Company ID from the fact table will come dynamically from the web and i have to find the region from which company id belongs to and then show all the companies associated to that region irrespective of what id user has passed.
To do this i made another fact table took the selected company id value from a measure and find out the region of that id and then filtered my new model with that and so bypass the page level filters.
So i have 2 fact tables one wil all tables and one with some required tables and i guess based on your replay i can say my approach is correct as its not formal to have multiple fact tables
Just reply your thought or any source which says this is okay.