Circular Dependency Issue

[bhmiller89]

I have a dataset with many tables. I used LOOKUPVALUE in a calculated column to get the column "Total Trade" into Table1

I need to calculate another calculated column called "Gross Profit" that uses "Total Trade" in the formula. however, I get "a circular dependency was detected: Table1[Total Trade], Table1[Gross Profit], Table1[Total Trade]

It needs to be a column and not a measure 

Any help is appreciated 

[Greg_Deckler]

Can you post your formulas and sample data as text? Circular dependency issues are notoriously thorny to troubleshoot.

[bhmiller89]

@Greg_Deckler  There is not a direct relationship between Table1 and Table2 so when I was calculating "Total Trade" in Table1 I used: 

Total Trade = Table1[VALUE1]+Table1[VALUE2]+ LOOKUPVALUE('Table3'[ Rate], 'Table3'[Key], Table1[Key])

Now I am trying to calculate 

Gross Profit = Table1[Value5]-Table1[Total Trade]- RELATED('Table4'[Value8])

that's where I get the error. Because I'm trying to use Total Trade in a calculated column and Total Trade is already using LOOKUPVALue.

Does that help?

[v-juanli-msft]

Hi @bhmiller89 

Could you show what are the relationships among these tables?

I need more information to rproduce this problem.

Best Regards

Maggie

[Greg_Deckler]

Yeah, but the circular dependency is not obvious to me. Are Table4 and Table3 related to one another? And is Gross Profit, what table is that in, Table1 or Table3 or ?