Why is this circular?

[Anonymous]

I am currently encountering a somewhat odd issue with a column that, just a few minutes ago, computed perfectly fine. Suddenly however, PowerBI seems to have decided that this is in fact a circular dependency, and I cannot figure out how it comes to that conclusion.

I am working with two tables, one that contains transactions (multiple per user, herafter referred to as T), and one that contains users (calling this U). Both are connected by the 1:* connection through UserIDs.

The column that briefly worked is set up as this: 

LOOKUPVALUE('U'[AcctCreationDate];'U'[id];'T'[id])

It should - and did - add the date of each transaction's respective account's creation. I cannot really see how this is a circular dependency, since it's a pretty straightforward lookup.

What is also odd is that the error shows a circular dependency between, "'T'[this column], c097ed7d-081f-4ad2-811d-3a3230285614, 'T'[this column]" - which doesn't really give me any useful information as to what exactly is circular about it either.

What am I missing?

[Ashish_Mathur]

Hi,

The LOOKUPVALUE() function works even without a relationship.  Delete the relationship and see if everything works well.

[v-cherch-msft]

Hi @Anonymous

Here is the article about understanding circular dependencies for your reference. It would be better that you could share your sample file for us to check and help further on it.

Regards,

Cherie

[Stachu]

are there any other columns that relate between the tables? If I read correctly this formula adds a column to T that's dependant on U
if there is a calculated column in U that's dependant on T it may cause cirlucar reference