rolling values up through multiple parents

The SQL here may not be exact, but it illustrates what I'm attempting. How do I write a DAX statement that gets me the same output?

Select issueid, sum(timespent), parentid

From (Select Select issueid, sum(timespent), parentid

From (Select issueid, sum(timespent), parentid from issues

Group by parentid) group by parentid) group by parentid;

Issues table looks like:

So what I’m looking for in regard to issueid 1 is to see the sum of timespent for issueid 1, 3, 5 and 6, and for issueid 2, the sum of timespent for issueid 2, 4, 7 and 8.