Forum Discussion

bstark1287's avatar
bstark1287
Helper II
3 years ago
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...
Need Help
  • GilbertQ's avatar
    GilbertQ
    3 years ago

    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's avatar
GilbertQ
Super User
3 years ago

Hi bstark1287 

 

It might work like this

 

CALCULATE(
SUMX('Raw Order Data',[Net Value]),
ALLEXCEPT(tbl_Calendar[OE USD]),
USERELATIONSHIP('tbl_Calendar'[Date],'Raw Order Data'[Order Cancelled Date])
)
  • bstark1287's avatar
    bstark1287
    Helper II
    3 years ago

    We are getting close! I used [Orders Entered] for my allexcept field because [OE USD] wasn't an option and [Orders Entered] is referenced in the error message as a cause for the circular reference. The first part of the dax statement seems to be working so now I just need to determine where to put the ALLEXCEPT in the second part I think.