Forum Discussion
Scheme probelm
Could anyone tell me is this scheme is correct? I know that there are loops in this scheme but is it possible to work good?
Thanks for answers.
Hi Anonymous ,
You can delete the two relationships in the red box, then set the Cross filter direction from Single to Both, which will treat the these tables as a single table . You can learn more : Create and manage relationships in Power BI Desktop .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Hi Anonymous ,
You can delete the two relationships in the red box, then set the Cross filter direction from Single to Both, which will treat the these tables as a single table . You can learn more : Create and manage relationships in Power BI Desktop .
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
All depends what do you want achived. This structure is hmm 'too nice' :). I wiem o czym piszesz. (sorry guys for local :) )
Data in tables in your model are 'mixed'. I mean in same table you have customer's and pieces data. I can't see 'Calendar' table in your scheme, and a few more 'basic' tables.
But to give you correct answer first we have to understand data and goal.
Pozdrawiam
Adam
Hi Anonymous ,
Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
