Forum Discussion

lcasey's avatar
lcasey
Icon for Post Prodigy rankPost Prodigy
9 years ago
Solved

Is this a Valid DAX/Power BI relation Model?

Does anyone know if this is a valid and optimal relational model for Power BI?  
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi lcasey,

     

    According to the picture provided above, I find that your table pattern has a loop like below:

    candmrel_crossfilterwithloops.png

    If you have a table pattern like that, with loops, then cross filtering can create an ambiguous set of relationships. So I would suggest you to change your table pattern, as cross filtering works well for a pattern of table relationships that look like the pattern below(star schema).

     

    candmrel_crossfilterstarschema.png

     

    For more details about how to create and manage relationships in Power BI Desktop, you can refer to this article.:smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi lcasey,

 

According to the picture provided above, I find that your table pattern has a loop like below:

candmrel_crossfilterwithloops.png

If you have a table pattern like that, with loops, then cross filtering can create an ambiguous set of relationships. So I would suggest you to change your table pattern, as cross filtering works well for a pattern of table relationships that look like the pattern below(star schema).

 

candmrel_crossfilterstarschema.png

 

For more details about how to create and manage relationships in Power BI Desktop, you can refer to this article.:smileyhappy:

 

Regards