topic Re: Circular dependency in DAX Commands and Tips

Circular dependency

WTAS80486 — Thu, 23 Feb 2023 14:41:13 GMT

HI, I am getting circular dependecy error. these two columns are calculated columns in a calclated table created from measures

Re: Circular dependency

amitchandak — Thu, 23 Feb 2023 15:09:59 GMT

WTAS80486 ,while above should work, it need to be measure

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

You can check

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

Re: Circular dependency

tamerj1 — Thu, 23 Feb 2023 15:13:50 GMT

WTAS80486
This should be a measure not a calculated column

Re: Circular dependency

WTAS80486 — Thu, 23 Feb 2023 16:20:24 GMT

Tech usage new is a measure

Re: Circular dependency

tamerj1 — Thu, 23 Feb 2023 16:39:26 GMT

WTAS80486

Look for the error in one of the calculated columns used in the measure's formula.

Re: Circular dependency

WTAS80486 — Thu, 23 Feb 2023 22:38:11 GMT

There are no errors in the calculated columns used in this measure, they populated correct data in the calcuted table, but when i want to divide the sum of both calculated columns in tech usage measure, this error comes