Forum Discussion

Vinnie's avatar
Vinnie
Icon for Helper I rankHelper I
3 years ago
Solved

Circular dependency in DAX column

Hi all,   I need help with a DAX column. Originally the column worked just fine but when I added some extra logic I got an error (circular dependency).   I am still trying to understand what a ci...
  • Vinnie's avatar
    Vinnie
    3 years ago

    I fixed this issue by adjusting the DAX statement for the DAX column DateMovedOutWorkingStock.

    I replaced 

     

    var dateinworkingstock = calculate(selectedvalue(File[DateInWorkingStock]))

     

    by:

     

    var dateinworkingstock = LOOKUPVALUE(File[DateInWorkingStock], File[ID], File[ID])

     

Vinnie's avatar
Vinnie
Icon for Helper I rankHelper I
3 years ago

Please let me know if I need to provide any needed information. I would of course want to fix it but also want to understand why I am getting this error.

I do see now that when I remove either the 'Working stock' DAX table OR remove the relationship between the File table and the 'Working stock' table, the DAX column does not give an error.