Data Modeling: Relationship Error while fetching data from 3 tables

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.