checking if multiple training modules are complete and mark as completed

Hi Jihwan_Kim 

In my real data, I need to know if each user has passed 10 specific training courses so they are can move forward to additional training. But the data from the training platform is messy sometimes the same training has multiple values in the passed column it can be not assigned, passed, or failed.

In my sample data:

In this case, everything is OK: the user has passed all training courses:

In this case: the user has worked for two companies, for company C everything is ok.

Company B the user has passed all 7 training courses but "training A" has a "Not Assigned" and "passed" condition so this should be marked as yes or passed in the measure but it is shown as no or not passed

Does this make sense?

Thanks

Sean.