Model Issue: Combining two Fact Tables

Hi Anonymous ,

Thank you for your reply, mickey64 . Here l have another idea in mind. Please check if there is anything that can be improved. Example data can be viewed from the attached .pbix file.Here is my solution:

Method1

1.Merge in the Power Query Editor:

2. Select the two fact tables to create a merged table:

3.Select Sales[$] to expand:

4.The model is shown in the figure:

Method2

1.Create a bridge table:

Bridge Table = SUMMARIZE('FACTProductRegionRatio','FACTProductRegionRatio'[Product Key],'FACTProductRegionRatio'[Region Key])

2.The model is shown in the figure:

Both of these methods can be able to filter the sales data from both dimensions:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!