Non-existent phantom "Column" column causing circular references

Hi SevsBo ,

It looks like Power BI has encountered a phantom circular dependency, likely due to internal metadata corruption or a hidden column reference. First, check for hidden columns using DAX Studio or Tabular Editor. You can run the following query in DAX Studio to list all columns in your model:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

If a column named "Column" exists, even if it’s not visible in the Fields pane, it might be interfering with your calculated column. Instead of copy-pasting, manually create the new calculated column with a slightly modified name, such as _ACV_Test instead of _ACV_2, and use VAR inside your formula to minimize dependency chains.

Try refreshing the entire report using Ctrl + Alt + F5, then save it under a different name and attempt to create the column again. Sometimes, relationships between tables can create an indirect circular dependency. Check the Model View and temporarily remove relationships involving your table, then try adding the column once more.

Clearing Power BI's cache can also help, as old column metadata might be causing the issue. Go to File > Options and settings > Options, then under Global, select Data Load and click Clear Cache. Restart Power BI afterward.

If the issue persists, consider moving the calculated column logic to Power Query instead of using DAX, as Power Query processes data before it enters the model, avoiding circular dependency issues. If none of these steps work, you may need to remove the table from Power BI entirely, re-import it, and then recreate the calculated column.

Let me know if any of these solutions help!

Best regards,