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 gives the correct results

So the DOT Status calc column checks if each rows arrival date time less than arrival cut off, if less than PASS else FAIL , if null then MISSING

for DIFOT Status how do i get a faill for all itemID of a conID as it has failed one? 

So the issue im facing is when i do a count of DIFOT PASS and DIFOT FAIL and MISSING based on conID it gives 1 count to each as DIFOT status has three different values (PASS , FAIL and MISSING)

So if there are 3 conID with 3 items each , all item id of 2 conID has passed all but if last conID has 1 pass 1 fail and 1 missing it gives each of the count to DIFOT PASS and DIFOT FAIL and MISSING , but as the last conID has 1 fail it should fail all it should count as 1 DIFOT FAIL

Please do let me know if you guys have any questions, thanks.