Forum Discussion
Circular dependency was detected
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
6 Replies
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.
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
Check the column in the Data model view or Power query editor. The column may be hidden in the report view.
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 TaoHi Anonymous
Below is the DAX for CSI
Example of other DAX
