Circular dependency was detected

[sglee]

When I create a new column, power bi auto creates another new column at back end and no show in my data table causing error for circular dependency was detected.

No "column" field found in my data table

[Anonymous]

Hi @sglee ,

It seems that [5 CSI] is a measure or calculated column, if it is, can you show me the DAX [5 CSI] used?
It is possible that the context in [5 CSI] is causing this error to be reported.

Best Regards,
Dino Tao

[sglee]

Hi @Anonymous 

Below is the DAX for CSI

Example of other DAX

[Musadev]

Hi @sglee 

If your code looks correct, that is if you do not see any obvious circular dependencies, then there are two possible causes for a hidden circular dependency:

• You are using context transition inside a calculated column.
• You are creating a relationship that involves either a calculated column or a calculated table.

Please check the link for more details and also share the Data model screenshot. 

[sglee]

I has been using this code for other report and the field in the code is within the same data table. The problem is I not able to found Survey[Column] in my data table. Noticed that after i created [2023 Satisfaction] it will appear [Column] but not found in the Survey data table

[Musadev]

Check the column in the Data model view or Power query editor. The column may be hidden in the report view. 

[sglee]

Have checked, there is no Column field hidden in power query editor