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

Hi lbenflin,

 

I've changed the link to a dropbox account that shares the .pbix file.

 

Thanks for your help and sorry I'm taking up your time.

 

Best regards,

 

Beefheart.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
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.