Power BI Report

I need help with applying a formula to filter the result of a column that is dependent on another column. Column 1 contains names of people and column 2 contains the status of column 1. A particulat name in column 1 can have one or more status. Status options are "Draft", "Complete", "Active". A particular name can have all 3 status types. What I wish to accomplish is to check if a name has 2 or more status, then a particular status should be chosen for that person's name. For example Name: Abel Samuel, Status: Draft, Complete, Active, If Abel's status is Complete, Draft and Active, then select Active or Overide other status and Abel's status should be "Active". kindly share your solution on how you would accomplish this. Thanks in advance.