Forum Discussion
Relationship Issues
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.
My first thought is that this is because the relationship between the customer and item can be achieved two ways and Power BI doesn’t know which one to use.
No, Power BI would have complained about the ambiguity and would have made one of the relationships inactive.
Think of it in terms of "Can I get there from here?" In Power BI that means "Follow the arrows".
Here is your data model, slightly rearranged. Dimensions on top, facts at the bottom
(Bidirectional 1:1 relationships often mean that the tables can be combined.)
As you can see your Item Code cannot travel to the customer side.
This data model might be more appropriate:
Hello lbendlin,
Thank you for replying!
Yes, I changed the relationships to match those in your second screenshot.
I then tried adding the Items[Code] column to the table in the report view and it stopped the table visual from working.
[EDIT: Link changed to use dropbox]
Here's a link to the latest version https://www.dropbox.com/s/ouhxi9iufc22sf0/Relationships.pbix?dl=0
Many thanks for your help and sorry to take up your time.
Beeheart.
