How do I make the value for each hierarchy level independent of other levels in a matrix

[Anushkas2003]

Hello!

I am trying to create a matrix where the rows are a set of tasks that need to be completed. The tasks have subtasks. Both the  tasks and the subtasks have statuses (that are independent of one another, i.e. task 1 (level 1) can be in progress, but a subtask can be completed). The statuses are the values in the matrix. However, I do not know how to set up the excel sheet and/or the hierarchy, to show these independent statuses. Most hierarchy examples I have seen only talk about numerical data, but this is non numerical. Statuses include: Not Started, In Progress, Completed, At Risk, Delayed

I began playing with some measures and below I ahve included what I have come up with so far. I know I must not use SUM but I do not know what else to do. Can someone please help me write this code in a way that achieves my goal above!

I need to solve this urgently, so any help would be amazing!

Thank you!

[TheoC]

Hi @Anushkas2003 

Can you kindly add example data and an example of the output you want.

Thanks,

Theo

[Anushkas2003]

Hi @TheoC!

Here is the kind of data we are working with!