Forum Discussion
Solved
Circular Dependency
I am trying to create a calculated column within my 'tbl_Calendar'. The dax I am using is: OE USD = CALCULATE( SUMX('Raw Order Data',[Net Value]) ) - CALCULATE( SUMX('Raw Order Data',[Net V...
Hi bstark1287
Why could you not create a measure for sales and a measure for cancelled orders.
Then you can subtract sales from cancelled.
When you put this into your visuals it will work it out automatically.
What happens if you put them into 2 seperate measures do you still get the error?
Yes same error. I did some reading and found this https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/ Based on the link I believe I need to add an ALLEXCEPT to my dax I am just not sure where. The article states