Thanks for the response Matthew. I don’t think that is going to work for us though.
Getting the project and tasks into a drill-able hierarchy is not the problem. The problem is creating a Overall Progress (for lack of a better name) measure that works more like a switch statement. So when the matrix is displaying the first level of the hierarchy, Project, it is displaying the Project Progress. ie 50%. When the matrix is drilled down on to the second level, Task Level 1, the Overall Progress measure shows the Task Level 1 Progress values. These can be 0-100% based on whether or not that Task has been completed, etc. You would then be able to drill down to the third level of the hierarchy, Task Level 2 to see the corresponding progress values for Task Level 2 Progress. These also could be 0-100%. So basically depending on what the row context of the hierarchy is, we would like to display the corresponding progress value for that level.
Hopefully that makes sense!