• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can't determine relationship between two or more fields


New Member
Hi there,
I got a data model which looks as follow:


I am trying to show columns from different tables in a table visual. Table visual works fine when I use columns from contact and AssetContact_Address tables. However, it throw an error 'cant determine the relationship between two or more fields' when I tried to put a column (any column) from the ContactRelationship table. I checked and there is no missing value in any table. I also changed the cross filter option from Single to both but did not work. Any help would be really appreciated.

Sample here.
I guess it is because your relationship cannot stream upwards from Address through Contacts and then downwards to Relationship.
I believe there might be a pattern described on the https://www.sqlbi.com/

Long shot: I vaguely remember an article about wrapping a measure inside calculate that somehow forces a "missing relationship" to work. I do not remember the source however. Sorry for that.

Maybe one of our data model heros will provide a better response.