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?
I'm confused again.
You say "previous picture in desired way, a 1 in the column if the row is of an "In type"" - so it's 1 on all rows (if a condition is met probably - I can guess that you want there to be a 1 if there is a 1 in any of the 'A In' or 'B In' or 'C in' columns (but you haven't stated this) .
Can there be a 0 in the column? otherwise I would just create a column like this:
NewCol = 1
and that doesn't seem to make sense.
Not half as confused as I am 🙂
You are correct, I missed some vital info.
Not all rows will get the 1 value since there are also other type of registrations that is not considered as in or out.
Thanks for your patience.