Forum Discussion
Solved
Strange Circular Dependency issue
I've made very simple pbix (only one table with 2 columns and 6 rows) where I've got circular dependency error in calculated column. Please, does anybody know what's wrong with this calculated colum...
- Hi askugor,
Let me first apologize for not looking at your formula correctly I was on my cellphone and not on the computer, it's not an excuse for pointing a bad answer but again sorry.
Regarding your question check the post below about circulary dependance.
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
As you can see the use of VALUES, DISTINCT and ALL in calculated tables can many times create circulary dependecy due to the internal dax motor and how this formulas are calculated.
Hope this helps, and my apologies once again.
Regards,
MFelix
Hi askugor,
Let me first apologize for not looking at your formula correctly I was on my cellphone and not on the computer, it's not an excuse for pointing a bad answer but again sorry.
Regarding your question check the post below about circulary dependance.
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
As you can see the use of VALUES, DISTINCT and ALL in calculated tables can many times create circulary dependecy due to the internal dax motor and how this formulas are calculated.
Hope this helps, and my apologies once again.
Regards,
MFelix
Let me first apologize for not looking at your formula correctly I was on my cellphone and not on the computer, it's not an excuse for pointing a bad answer but again sorry.
Regarding your question check the post below about circulary dependance.
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
As you can see the use of VALUES, DISTINCT and ALL in calculated tables can many times create circulary dependecy due to the internal dax motor and how this formulas are calculated.
Hope this helps, and my apologies once again.
Regards,
MFelix
Dear MFelix,
no need to apologize:)
Thanks for looking at it so quickly.
I wasn't aware of this peculiarity with VALUES, DISTINCT and ALL in CALCULATE regarding circular dependency and internal DAX engine.
Thanks again
Best regards
Alen