Forum Discussion

Beefheart's avatar
Beefheart
Icon for Helper I rankHelper I
3 years ago
Solved

Relationship Issues

Hello Everyone, I think I have a relationship problem. I’ve attached a pbix and a screenshot of the relationships is below.     Basically, we have customers that own assets and those asset...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    There is no relationship between customers and components. Therefore you cannot show these in the same visual.

    Same issue between items and assets.

     

    You could work around this by denormalizing some of the tables,  but it may also be a case where the question you are trying to answer with the report needs to be reconsidered.

Beefheart's avatar
Beefheart
Icon for Helper I rankHelper I
3 years ago

Hello lbendlin,

 

Thank you very much for your help.

Unfortunatly, my problem persists, I cannot put the Item's Code in the table on Page 1 without it breaking and giving a "Can't determine relationships between fields" error.

 

Do you have any advice on how I can get this working please?

 

Thanks again for your help,

 

Beefheart

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    Did you make changes to the data model? Can you please post the updated pbix file?