Circular Dependency with LOOKUPVALUE

[Gonqq]

Hi , i'm currently using lookupvalue on some calculated columns and i can't seem to understand as to why the circular dependency is happening. Screenshots:

Any help would be highly appreciated.

Thank you

[PaulDBrown · Accepted solution]

See if this video from the gurus at SQLBI helps:

Avoiding circular dependency errors in DAX 

[Greg_Deckler]

@Gonqq Is Regras[CVEE- FC] a calculated column?

[Gonqq]

Hi @Greg_Deckler . Regras[CVEE- FC] is a column from the Table Regras which i import from excel.

Screenshot of a part of table Regras:

[PaulDBrown · Accepted solution]

See if this video from the gurus at SQLBI helps:

Avoiding circular dependency errors in DAX 

[Gonqq · Accepted solution]

Hi @PaulDBrown. The video was very clear and I was able to understand why it was happening. That calculated column and the lookupvalue had all the columns from the table BALANCETES depending on it, which means when calculating CVEE-FC it was including the CSEP column.
All i had to do was adding CALCULATE and ALLEXPECT to reduce the columns to what i wanted.
Printscreen:

Thank you so much, this was bothering me for a long time.