Forum Discussion
circular dependency when adding two independent calculated columns
I have a table with PRODUCTS and a table with SALES (linked to each other with ProductID), and a DATE table (linked to SALES table) I want to calculate the average sold items per product in the l...
following on your suggestion to add sample data, I create a simple dataset. However, my sample does not have this problem, so it has something to do with my real-life data dsf ☹️
BTW: how can I add attachments (I don't see any upload button to attach my sample)
HI KJanssens
I have tested on my side, it works well.
Please make sure you add these two calculated column in PRODUCT table not SALES table.
and here is my sample pbix file, please try it.
and This is a good refresher on circular dependencies: https://www.sqlbi.com/articles/understanding-circular-dependencies/
For your sample pbix file, yu can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Lin