Forum Discussion
2 fact tables simultaneously?
I have a standard matrix visual in Power BI, which is displaying around 8 measures. The matrix uses a Fact table, 2 dimension tables and a DimDate. So far, it works as expected, but now new d...
Hi Anonymous ,
You may consider creating a relationship between the two tables. When you import multiple tables, chances are you'll do some analysis using data from all those tables. Relationships between those tables are necessary to accurately calculate results and display the correct information in your reports.
Please refer to the following document for further information.
https://docs.microsoft.com/power-bi/transform-model/desktop-create-and-manage-relationships
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.