Forum Discussion
Solved
CountA columns, working on 2 columns, gives circular ref on all others
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 eac...
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])
Thats brilliant, thank you for the help, my laptop is no longer getting abused.