Forum Discussion

Beefheart's avatar
Beefheart
Helper 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.

LP280388's avatar
LP280388
Resolver II
3 years ago

Hi lbendlin ,

Powerbi expects an aggregation when you are bringing a column from tables which are not related directly like in your case.

 

So, Probably you can use an aggregation on your Item Code column when you add it in the visual.  Item Code, I guess its a String so you can choose an aggregation as first/last as shown below.

 

 

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Great comment.  You would still have to make sure that the chosen aggregation makes business sense.

     

    For example here I have no idea if the displayed data makes sense.