I have an issue where Commissions are calculated based on Collected Revenue but I then need to add Commissions and Collected Revenue together for additional calculations later.
I attempted to just create a calculated column with Expense Load = [CollectedRevenue]+[Final Commissions] but received the error: A circular dependency was detected: Sum Gross[Final Commissions], Sum Gross[Column], Sum Gross[Final Commissions].
If you still need help, please share your dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Community Support Team _ Cherry Gao If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.