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.
This takes care of the circular reference (picture 1) but does not total (picture 2). Basically what I am wanting it to do it sum the total net value of the calendar date that an order was created on (so if 4 orders for $1 were created on 1/1/22 then it would show $4 on 1/1/22) then subtract the total net value of cancelled orders on 1/1/22 (so if one order was cancelled on 1/1/22 for $2 it would subtract $2 from the $4).
I have a similar calculated column that is working in [Orders Entered] (picture 3).
1.
2.
3.