Forum Discussion
Solved
Circular dependency error in switch(true)
I need help on resolving circular dependency error on my formula: Sales Level = SWITCH(TRUE(), 'Sales'[Sales by Product]>=1000000,"Level1", 'Sales'[Sales by Product]<=999999 && 'Sales'[Sales by P...
Hi summer18 ,
Is Sales by Product a calculated column? If so try this instead:
Sales by Product =
CALCULATE (SUM ( 'Sales'[Actual] ),
ALLEXCEPT( 'Sales'[ProductID] )
)
Have a read of
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Which explains why you get circular dependency.
Hi summer18 ,
Is Sales by Product a calculated column? If so try this instead:
Sales by Product =
CALCULATE (
SUM ( 'Sales'[Actual] ),
ALLEXCEPT( 'Sales'[ProductID] )
)
Have a read of
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Which explains why you get circular dependency.
