New column for like all rows of duplicate in column A if value appears in column C

[PHenderson]

Good afternoon, thank you in advance for any suggestions. 

I have a dataset for employee names and training courses they have completed or not.

Column A is a list of employee numbers, B is course names, and C is completed status.

I need a new column D to show the employee as Success or Fail. Success is that all courses are completed (ie. for employee 1, if any "Not complete" appears in any row where Column A has '1', column D would show 'Fail' for each of those rows.
Likewise in the example below, employee 3 would be a 'Success'.

Many thanks

[some_bih]

Hi @PHenderson  add new column Success of Fail = IF (<Your table name>[Complete Status]="Not complete" , "Fail", "Success") 

Kudos if this help

[PHenderson]

Hi, thanks for your suggestion, but I don't think I was clear enough. I'd need 'Fail' in column D for each row for that employee if even one of the rows for that employee has 'Not Complete' in column C. 
- Essentially, employee is listed as fail if they haven't completed each of the 5 courses.

Thanks

[some_bih]

Hi @PHenderson create measure Success or Fail as below.

Mark my post as a solution and give kudos if this help you!

Success or Fail =

VAR _calculate_not_complete_status=

CALCULATE(

    DISTINCTCOUNT(Sheet1[Complete Status]),

    Sheet1[Complete Status]="Not Complete"

)

VAR _Result=

IF(_calculate_not_complete_status=BLANK(),"Success","Fail")

RETURN _Result