Forum Discussion
Post ProdigyA circular dependency was detected
Post ProdigyHi PaulDBrown
I understood from the video that I need to reduce dependency list of the column, to consider only the needed column.
I am doing the all except in my 'Mix' calculated column and still not working.
So, on excel would be this:
And translated to dax I get:
The error on my 'Capacity' calculated column is directly related to my Mix calculated column above.
The capacity column is not a calculate function, just an IF. So I guess the root cause must be on the mix column.
Do you know what can I do based on my code?
Thanks.
Community ChampionI would try wrapping the IF column in CALCULATE with ALLEXCEPT. Actually, you should do so with all calculated columns: the video states that all calculated columns need the ALLEXCEPT
- o59393
Hi PaulDBrown
If I try to wrap the if colum with calculate, this happens:
Columns are underlined with red.
Regards.
- PaulDBrown
Apologies since I can't see the image clearly. However, try putting the IF expression in a VAR and then do the CALCULATE with ALLEXCEPT as the RETURN expression
- o59393
Hi PaulDBrown
You can click on the image and it will expand. What column should I use within allexcept?
Please click in image below to zoom in:
Regards.