Forum Discussion
Helper IIICircular dependency error in switch(true)
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.
Community ChampionHi summer18
Please try this
Sales Level =
SWITCH(TRUE(),
'Sales'[Sales by Product]>=100000,"Level3",
'Sales'[Sales by Product]>=500000,"Level2",
'Sales'[Sales by Product]>=1000000,"Level1",
"Level4"
)
If not work, please share sample data or pbix file.
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
summer18Hi PijushRoy , it did not work. I think I have to remove the circular dependency on ProductID but I don't know how.
- bcdobbs
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.