Forum Discussion

ConstMoss's avatar
ConstMoss
Icon for Helper I rankHelper I
9 years ago

ambiguous relationships in Power BI model

hello everyone -      we have the following transaction tables - orders (from customers), invoices, and ledgers.  and three dimensions (customers, products, region) The dashed lines are man...
Need Help
ConstMoss's avatar
ConstMoss
Icon for Helper I rankHelper I
9 years ago

hi Dale (@v-jiascu-msft) - thanks for your response.

 

direct relationship between invoice and ledger is not possible so i am using a bridge table to connect them. i can work on putting togther a pbix file for you. can you think of any other solution?

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi ConstMoss,

 

Please share your .pbix file. You can upload it into the cloud driver then share the link here or through private messages.

 

Best Regards!

Dale

  • ConstMoss's avatar
    ConstMoss
    Icon for Helper I rankHelper I
    9 years ago

    Hi @v-jiascu-msft

     

    i just uploaded the model and sent you the link using private message. please let me know if you need anyhting else. thanks for your help.