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.

     

v-xicai's avatar
v-xicai
Community Support
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.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you for answer :)

  • AdamBoltryk's avatar
    AdamBoltryk
    Resolver 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
        Resolver 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