Circular dependency was detected: Lookupvalue

Hi Ashish,

I can't share specific data so i'll generate information to mimic this issue.

Say I have:

table A (Training List) which has pre-populated columns training ID, training hrs, training expense and training fee where training ID is the key column.

table B (Staff List) which has pre-populated columns staff no, staff rate where J is the key column.

table C (training req) which has columns training id, staff no

This is imported into PowerBI from Excel.

I am creating two columns in table C, as follows:

TimeCost = LOOKUP(table_A[training hrs],table_A[training ID],table_C[training ID])*LOOKUP(table_B[staff rate],table_B[staff no],table_C[staff no])

ExpCost = LOOKUP(table_A[training expense],table_A[training ID],table_C[training ID])+LOOKUP(table_A[training fee],table_A[training ID],table_C[training ID])

Both formulas seem to work fine and whatever I choose in the first column works. However, when I open the second column to add information in, I get the following error:

A circular dependency was detected: Table_C[TimeCost], Table_C[ExpCost], Table_C[TimeCost].

I know a circular dependency is one depending on another which then makes it difficult to manage but in neither of these columns do I reference TimeCost or ExpCost so I don't see where the circular reference is.

Could someone help please?