CountA columns, working on 2 columns, gives circular ref on all others

[AndrewWestley]

Hello there, starting to tear my hair out but fairly new to PowerBI. I'm making calculated columns to allow for a table visual on my report, showing how many outstanding issues each owner has for each group. I've managed to successfully make 2 calculated columns using the same formula, but changing the reference field names. After that, any subsequent fields fail, showing a circular reference and i'm totally lost as to why. Any help would be gratefully appreciated.

[AndrewWestley]

Thats brilliant, thank you for the help, my laptop is no longer getting abused.

[AndrewWestley]

Sorry, thought i'd just add another of the formulas that works perfectly

[Azadsingh · Accepted solution]

Hi Andrew, please try below solution if you are still facing the circular dependency issue 

create a flag

Checklist_Overdue_Flag =
IF(table_query_2[checklistoverdue] = "yes", 1, 0)

Then, you can create a measure to count the number of overdue checklists:

Measure_Overdue_Count = SUM(table_query_2[Checklist_Overdue_Flag])