Forum Discussion
Is this a Valid DAX/Power BI relation Model?
Does anyone know if this is a valid and optimal relational model for Power BI?
Hi lcasey,
According to the picture provided above, I find that your table pattern has a loop like below:
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).
For more details about how to create and manage relationships in Power BI Desktop, you can refer to this article.:smileyhappy:
Regards
1 Reply
Hi lcasey,
According to the picture provided above, I find that your table pattern has a loop like below:
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).
For more details about how to create and manage relationships in Power BI Desktop, you can refer to this article.:smileyhappy:
Regards