Forum Discussion
Solved
Calculated column Circular Dependency issue
Hi Guys, I am trying to get the result based of certain conditions to get PASS, FAIL AND MISSING for the DIFOT Status column is a Calculated Column and DOT Status is also a calculated column which gi...
maybe you can try this
Column =VAR _DOTCHECK=maxx(FILTER('Table','Table'[conID]=EARLIER('Table'[conID])&&'Table'[DOT Status]="FAIL"),'Table'[conID])VAR _DIFOTCHECK=maxx(FILTER('Table','Table'[conID]=EARLIER('Table'[conID])&&'Table'[DIFOT Status]="FAIL"),'Table'[conID])return if(ISBLANK(_DIFOTCHECK)&&ISBLANK(_DOTCHECK),"Pass","FAIL")
