Forum Discussion
Data modelling advice - multiple factless fact tables and date tables
HI jon_w.
What type records did these two fact table stored? Did they store with the same data structure or stored records with summary and detail level records?
If you mean the first one, I'd like to suggest merge two table with custom fields to remark the root table of these records. If you mean summary/detail level, you can build main relationship on the summary level table(star schema) and link detail table with summary table instead directly build all relationship keys on these two tables.(current power bi data model only allow one active major relationship, other will auto turned to inactive or they will cause the conflict about relationship and aggregation)Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
BTW, for some disconnected tables interactions, you can create filter/slicer to apply filter affect. these effect can be extracted and applied in dax expressions.
Regards,
Xiaoxin Sheng
HI jon_w.
What type records did these two fact table stored? Did they store with the same data structure or stored records with summary and detail level records?
If you mean the first one, I'd like to suggest merge two table with custom fields to remark the root table of these records. If you mean summary/detail level, you can build main relationship on the summary level table(star schema) and link detail table with summary table instead directly build all relationship keys on these two tables.(current power bi data model only allow one active major relationship, other will auto turned to inactive or they will cause the conflict about relationship and aggregation)
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
BTW, for some disconnected tables interactions, you can create filter/slicer to apply filter affect. these effect can be extracted and applied in dax expressions.
Regards,
Xiaoxin Sheng