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 discovered that I had complicated it too much, by just adding up the columns required for the new in and out columns I worked it out. Thanks to all your help I discovered it was me all along...
I obviously messed it up by mixing row and column functions into one in my head but by just following my original logic I got the result I wanted.
You really should not complicate things too much 🙂