Strange Circular Dependency issue

[askugor]

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 column?

[MFelix]

Hi @askugor,

You are calculating a column and then placing a filter on the full table this includes the calculated column so the circular dependency.

Try to change the table in filter to ALL(TestTable[NR]).

Regards,
MFelix

[askugor]

Thanks MFelix,

then I have another question:)

Why this slightly changed formula doesn't make circular dependency:

TestColumn = CALCULATE(CONCATENATEX(TestTable;TestTable[Name];"-");FILTER(TestTable;TestTable[Nr]<EARLIER(TestTable[Nr])))

I've just removed VALUES and didn't insert ALL.

Thank you

[MFelix · Accepted solution]

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

[askugor]

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