You could convert the Pass/Fail to 1/0, and turn that formula into a KPI.

Then do something like:

CASE WHEN

PU_SUM(ID, KPI(q_check))/PU_COUNT(ID,KPI(qcheck)) = 1

THEN

'All Pass'

Else

'Fail'

END

I'm not sure about your table structure. But you'd have to use a DOMAIN_TABLE(ID) in the PU-Functions above if everything is one one table.

I agree with @connor.manth. After Counting, I would apply a component filter something like...

FILTER PU_COUNT(DOMAIN_TABLE("Table"."ID"), "Table"."Activity", "Table"."Timestamp", "Table"."q_check" IN_LIKE ('Fail')) = 0;

It means, if there will be 'Fail' in of the IDs, that ID should be ignored. In your example above, in ID=2 there is one Fail and one Pass, with this logic ID=2 should be completely excluded.