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.
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.
Looks like you linked to the virtual machine image instead of the pbix file. Might want to correct that.
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.
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.