Forum Discussion

browncp88's avatar
browncp88
Frequent Visitor
3 years ago
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...
Need Help
  • DataInsights's avatar
    DataInsights
    3 years ago

    browncp88,

     

    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.

DataInsights's avatar
DataInsights
Super User
3 years ago

browncp88,

 

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.

  • browncp88's avatar
    browncp88
    Frequent Visitor
    3 years ago

    Thanks, your graphic showed me the issue I was having - needed to have single direction cross filters rather than bi-directional, which was selected.  Appreciate the help!