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.
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.
You are a hero! The measures worked. For some reason I thought that measures wouldn't work. For reference of others the measures I used are posted below.
Glad to hear I could help!
