Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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.   
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    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.

     

AdamBoltryk's avatar
AdamBoltryk
Icon for Resolver I rankResolver I
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Dziękia Adam za odpowiedź. :)

Pozdrawiam.

  • AdamBoltryk's avatar
    AdamBoltryk
    Icon for Resolver I rankResolver I
    7 years ago

    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