Forum Discussion
A circular dependency was detected
I have this formula:
Though I do not understand why, I cannot reference this column in this formula. I instead tried to use a measure to build this, but when I try to do that, my [NPS Level] column is not available for choosing for whatever reason. How do I get around this?
4 Replies
Hey,
I'm wondering if the column that is referenced by your formula is a calculated column, maybe you can share a pbix file with some sample data, upload the file to onedrive or dropbox and share the link to the file.
Here is a link to an article that maybe helps you to discover what's going on and also resolve your issue:
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Regards
Tom
TomMartens yep that's it. I unfortunately cannot share the file since it is actual company data being used. I'll have to find a workaround somehow... I simply wish to just reference the column based on criteria within the same table.
Hi Anonymous,
Can you integrate these columns into one calculated column? Or maybe you can share a dummy sample. The reasons and solutions vary from case to case.
Best Regards,
Dale
