Forum Discussion
Strange Circular Dependency issue
- 7 years ago
hi, DouweMeer
It is not a bugger, it is a common problem between calculate column and relationship
https://www.sqlbi.com/articles/understanding-circular-dependencies/
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
You can upload sample pbix file and expected output to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
hi, DouweMeer
Could you please share a simple sample pbix file for us to have a test :smileyhappy:
Best Regards,
Lin
Actually, I didn't though I could reproduce it. That is what always happens when I have these strange cases. But I'm hit with the problem that I can't attach attachments to the forum and other apps that will let me do it, are disabled by my company. Any chance you can pm me that I can send you the file?
Otherwise, I think I found the bugger. But I still don't know why.
When I try to enable the 'both' relationshipWhere the problem is and its expression
- v-lili6-msft7 years ago
Community Support
hi, DouweMeer
It is not a bugger, it is a common problem between calculate column and relationship
https://www.sqlbi.com/articles/understanding-circular-dependencies/
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
You can upload sample pbix file and expected output to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
- DouweMeer7 years ago
Impactful Individual
OneDrive with external link is block by policy. Sorry, not going to work.