Forum Discussion
bstark1287
Helper II
Helper IICircular 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.
GilbertQ
Super User
Super UserWhat happens if you put them into 2 seperate measures do you still get the error?
bstark1287Helper II
Helper IIYes 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