Counting the number of time an employee failed a test

[Dhaii]

• I have a table that has the emplyoee ID, test date, and result(passed,failed, neutral). I want a separate table with two cloumns ( the employee ID, number of times failed)

I copied the table and only took the ID column and removed duplicates. Now I want to create the other column in which it has the number of time this employee ID failed the test.

anyone know how such a thing could be accomplished ???

[Ahmedx · Accepted solution]

column=
COUNTROWS(
Filter(ALL(table_1),table_1[emplyoee ID]= table_2[emplyoee ID]&& table_1[result]="failed"))