Forum Discussion
Helper Vneed help dax measure
Hi Hussein_charif ,
The circular dependency occurs when RemainingAmount is calculated based on AdjustedBudget, while AdjustedBudget also depends on RemainingAmount, creating a recursive loop that DAX cannot handle.
To prevent this, the CumulativePreviousRemaining measure should use only the raw budget and actuals from previous months with a SUMX + FILTER approach, without referencing AdjustedBudget or RemainingAmount. This keeps the carry-forward logic independent and avoids circular references.
Please check your logic to make sure no recursive dependency is present.
Thank you.
Hi Hussein_charif
Thank you for reaching out to the Microsoft fabric community forum. Thank you bhanu_gautam for your inputs on this issue.
After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used sample data on my end and successfully implemented it.
I am also including .pbix file for your better understanding, please have a look into it:
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
Hussein_charifhi Anonymous , thank you for the reply. i tried your exact approach before, which was almost all correct except when i got to a circular dependancy when adjusting the cumulative remaining
Hi Hussein_charif ,
The circular dependency occurs when RemainingAmount is calculated based on AdjustedBudget, while AdjustedBudget also depends on RemainingAmount, creating a recursive loop that DAX cannot handle.
To prevent this, the CumulativePreviousRemaining measure should use only the raw budget and actuals from previous months with a SUMX + FILTER approach, without referencing AdjustedBudget or RemainingAmount. This keeps the carry-forward logic independent and avoids circular references.
Please check your logic to make sure no recursive dependency is present.
Thank you.