Splitting a count on field from an when value 'IN'

Hi,   In my set of data I have a fact table of tasks.  An asset gets inspected on a particular 'task code' and that 'task status' goes to completed and raises various other outstanding task codes....