Forum Discussion
Replace Index with Values
That's quite a handful.
This part needs cleaning up. Combine Location,Country and Region into one table, and clean up your "region" terminology. Your title region seems to be different from your geographic region.
Bidirectional 1:1 relationships most of the time mean you should fold the tables into a single table.
I think you have more than two fact tables. In fact (pun intended) you may not have fact tables at all. This gets close to a graph, and frankly is not something Power BI is good at. The Qlik associative model is more suited for such a scenario.
Can you try to formulate the main questions that your report should be answering for your intended audience? That may help to modify the data model in a meaningful way.
Super UserThat's quite a handful.
This part needs cleaning up. Combine Location,Country and Region into one table, and clean up your "region" terminology. Your title region seems to be different from your geographic region.
Bidirectional 1:1 relationships most of the time mean you should fold the tables into a single table.
I think you have more than two fact tables. In fact (pun intended) you may not have fact tables at all. This gets close to a graph, and frankly is not something Power BI is good at. The Qlik associative model is more suited for such a scenario.
Can you try to formulate the main questions that your report should be answering for your intended audience? That may help to modify the data model in a meaningful way.
Many thanks for the help and advice lbendlin . I modify the questions in order to ease the help of the audience.