Circular dependency

[DeBIe]

Hey all,

I'm trying to wrap my head around this and looked for a solution on the internet, but can't get the right outcome. Can you please help? I illustrated my problem below. In green is the first calculated column that I have added. In Red is the second column that I had, but it tells me I have a circular dependency between the two columns. I found out that PowerBI gives this error because it does not know which column needs to be calculated first. But how to solve it?

Extra info: the tables are related to each other via the invoiceID.

Thank you for looking into this!

[DeBIe]

Any other suggestions?

[SpartaBI]

@DeBIe try:

IsDoubleCheckAndIsUpdatedDetail = 
CALCULATE(    
    IF(DoubleCheck = 1 && IsUpdatedDetail > 0 ,1 ,0) ),
    CROSSFILTER('InvoiceDetail','InvoiceHeader', NONE)
)

[SpartaBI]

Or this:
IsUpdateDetail =
VAR _ID = 'InvoiceHeader'[InvoiceID]
RETURN
CALCULATE(
    SUM(InvoiceDetails[IsUpdated),
    REMOVEFILTERS('InvoiceHeader'),
    'InvoiceDetail'[InvoiceID]) = _ID
)

[amitchandak]

@DeBIe , Are you trying to use columns across tables?

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[DeBIe]

Hey @amitchandak ,

I pulled in the sum amount of "IsUpdated" column to my InvoiceHeader table. That works fine. The problem of circular dependency occurs when I create another calculated column after that, which checks if "IsUpdatedDetail"=1 and "DoubleCheck" =1.

It is saying that there a circular dependency between columns "IsUpdatedDetails" and "IsDoubleCheckAndIsUpdatedDetail"