Scheme probelm

[Anonymous]

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. 

[v-xicai]

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

[v-xicai · Accepted solution]

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.

[Anonymous]

Thank you for answer 🙂

[AdamBoltryk]

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

[Anonymous]

Dziękia Adam za odpowiedź. 🙂

Pozdrawiam.

[AdamBoltryk]

WMac23,

No problem.

Please take a look on structure of relations in my data model. It's why for me your structure looks 'to simple' 🙂 I admit, your data don't have to be so complicated as mine, but as I said - firstly we have to understand source data and purpose of the report. If you need more assistance, please do not hesitate to contact me 🙂

Regards,

Adam