Combining Two Columns (Calculated) But Getting Circular Dependency Error

[DMB90]

I have the existing formulas below in two separate columns that I want to combine into a new single column but I am getting a circular dependency error (picture attached) :

First:

3.Errors = if(and('Timesheet'[Activity Type]="Control",calculate(Sum('Timesheet'[2.Walkthrough])+sum('Timesheet'[2.Design])+SUM('Timesheet'[2.Interim])+SUM('Timesheet'[2.Rollforward])+SUM('Timesheet'[2.Annual])+SUM('Timesheet'[2.Remediation]))<>calculate(sum('Timesheet'[Hours]))),"Errors","")

Second:

0.BlankProcess = if(and('Timesheet'[Activity Type]="Control", 'Timesheet'[0.Adj Process]=BLANK()), "Errors", "0")

I want to combine the two columns, into a new column to basically say if the first column is equal to "Errors" and the second column is equal to "Errors", then "Errors" and if not then Blank.

[FreemanZ · Accepted solution]

hi @DMB90 ,

try change it to:

3.Errors =
IF (
    AND (
        'Timesheet'[Activity Type] = "Control",
        ([2.Walkthrough] 
            + [2.Design] 
            + [2.Interim] 
            + [2.Rollforward] 
            + [2.Annual] 
            + [2.Remediation] )
            <> [Hours] 
        )
    "Errors", ""
)

p.s. try not to use CALCULATE in calcualted columns, context transition can spoil the calculation easily.

[DMB90]

Thank you. This resolved my issue. Thanks for the tip to avoid using CALCULATE as well.