Forum Discussion
Circular dependency - Odd table
It's better to 'show' what you're doing rather than explain it in words (sometimes both are required). A small test data sample with the DAX for the calculated columns.
--
The error message says - CSV[Column] depends on CSV[Out] which depends on CSV[Column]. There might be no explicit connection between these two to the untrained eye but powerbi sees a connection.
Let's look at the column code you have provided:
Out = calculate(sum(CSV[A Out]) + sum(CSV[B Out]) + sum(CSV[C Out]) + sum(CSV[D Out]) + sum(CSV[E Out]) + sum(CSV[F Out]) + sum(CSV[G Out]) + sum(CSV[H Out]) + sum(CSV[I Out]))
This looks like it could be done simpler. Why is the calculate there? Is the SUM keyword required? Can you show what you are trying to do here (with an example) please?
Thanks,
I have read the article but it still does not help in explaining to me,
Unfortunately I am very new and by that it may be hard for me to translate explanations to my own examples. I have probably built the logic in a more difficult way than necessary.
Not very good at DAX or even excel language from start but trying to learn.
"If your code looks correct, that is if you do not see any obvious circular dependencies, then there are two possible causes for a hidden circular dependency:
- You are using context transition inside a calculated column.
- You are creating a relationship that involves either a calculated column or a calculated table."
I do not understand the part of context transition. Can you elaborate what that means? Best guess for me now is that this may be the problem.
The columns are not calculated, just displaying a value based on an IF assumption.
They are not referring to eachother in any other way than being a result of the two original ones.
Obviously I am missing something, just can´t find what.
What is the tables primary key? The first row of the column?
Will try the allexcept version but that will be many columns to exclude.
It is possible to calculate one or the other, I can get correct values for a summary of both in and out but I can´t have both at the same time, don´t know if this helps in figuring out the issue.
Both calculations refer to separate columns, no duplicates in between.