Circular refernece when creating a relationship

[masplin]

Scratching my head about this

I have created a calculated column

Team = CALCULATE(VALUES(Team[Team]),FILTER(Team,Team[Client]=AdviserRole[Client]))

and then I tried to create a relationship between this and Team[Team] but says it is a circular dependency

 However i did exactly the same on another table and works fine?

Team = CALCULATE(VALUES(Team[Team]),FILTER(Team,Team[Client]=AdviserRole[Client]))

Relationship is with AdviserRole[Team]

The first table has no other relationships.  Can anyone explain why this might be as can't see it?

Thanks

Mike

[v-xuding-msft]

Hi @masplin ,

You may take a look at the following articles.

• https://www.sqlbi.com/articles/understanding-circular-dependencies/
• https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

If you still can't solve it, please share a few screenshots about your situation. Or please share some sample data and expected results. Then we will understand more clearly. Thanks!