Forum Discussion
Solved
Multiple Dimensions, Multiple Facts Data Model
Is it possible in Power BI to model multiple dimensions and multiple facts? To simplify from first-principles, imagine I have two fact tables: 1) Stock Data Time Series (Asset Class, Date, Price...
Yes, you can model multiple dimensions and multiple facts. Create a relationship between each fact table and the dimension tables as shown below:
You can add as many fact tables as you need. In a visual, use fields from dimension tables and you'll be able to see measures for each fact table since the fact tables share dimension tables.
