Forum Discussion
Data Modeling: Relationship Error while fetching data from 3 tables
Hello PBI_Member_01
try adding a measure from table : occuption geo ,
this should fix the problem .
if not, if possible, please share the pbix file so i can take a look
best regards
Hello Daniel,
Thanks for your input on this.
If I add a summarized column, it does show the information, but if I include unsummarized column, the relationship error gets thrown. My end goal would be to show descriptive information from this table.
My question would be, What if instead of summarized data, I want to display some unsummarized column's information on the table? Why would that cause a relationship error?
Also, as shown in the screenshot above, why is the unsummarized column, from Table A, able to slice the data correctly for Table C and no error is thrown at that point?
I am just trying to understand the reason behind this behaviour so that I can modify my Data Model accordingly.
Thanks again.can you please share the pbix file. it is easier for me to interpret and answer your questions .
you can share via a link to google drive or dropbox if you want.
best regards
Sure, here is the link for the file:
PBIX File
Thank you for providing relevant material to this problem, Daniel.
For the issues discussed in the attached links, I see that there is a bi-directional relationship on either side of the two tables, whereas in my case, there is only one bidirectional relationship with the occupation table while the occupation table is single directional towards the occupation geo bridge table.
Still finding it difficult to understand why the relationship would break in this case since there isn't bidirectional on both sides of the Table B, it exists only between Table A and Table B.
