Forum Discussion

drew989898's avatar
drew989898
Frequent Visitor
11 months ago
Solved

Error: A circular dependency was detected

Hi, I'm hoping to get some help on a problem I'm having with a circular dependency. I understand why I'm getting this error, but I'm not sure how to work around it to get the result I require. I hav...
DAX
power bi
  • Gabry's avatar
    Gabry
    11 months ago

    Hey buddy,

    I’m not completely sure I understood all the requirements. Assuming you have a key on emp id, I created a file for you, please take a look and let me know.
    I should mention that if you create a table using CALCULATETABLE, the data will actually be stored in the model. That makes me wonder if maybe you’d prefer to do it using only a measure instead.

     

     

    EDIT: I updated the file, I put also a measure to do the calculation you need. Let me know if this solve your issue

Gabry's avatar
Gabry
Super User
11 months ago

Cool, I'm happy to hear that!
Keep in mind that the LOOKUP DAX function isn't supported when the table is in DirectQuery mode. Also, it's considered best practice not to add calculated columns to DirectQuery tables. If you plan to use the source table in DirectQuery mode, it's better to use a measure instead.

drew989898's avatar
drew989898
Frequent Visitor
11 months ago

No worries. This is easy enough to convert to a measure using MAX(), which seems to work well enough.


Start date-Time availability2 = LOOKUPVALUE('Table'[Start Date-Time],'Table'[Emp ID],MAX('Table'[Emp ID]), 'Table'[Type], "Availability")


So I think I can forge ahead with this solution!

If I were able to do some of this ETL stuff with SQL that would be great. But I'm limited to power query and DAX.
Thanks again, Drew.