How to solve relationship between tables with circular reference?

Hello all!

I am struggling to get a solution for the following problem. Any help will be hugely appreciated!

Context:

I have two tables to work with:

Table 1: contains a list of items. One column is the item unique ID, and the other columns are information about the item, like status and dates.

Table 2: contains basically two columns: "Item ID" (for reference) and "Item ID child".

So, if I filter Table 2 by an ID, I get all its children as a result.

For example, let's say the items are: "Projects", "Tasks," and "Subtasks".

ID #1 is a project.
It has #2, #3, and #4 as children. #2 and #3 are tasks, and #4 is a subtask directly linked to the project.

Task #2 has "subtask #5" as a child.

Schematic of dataflow (the numbers represents the steps ordering)

Objective:
My goal is to be able to summarize tasks and subtasks by projects and their statuses.

I have tryied duplicating the tables, creating relationships, creating custom measures... but I can get the visuals to work properly because I am having trouble with the circular reference between thore two table or I can filter properly because I have duplicated the tables and can´t make a link between them.

Help

What is the best approach to achieve that?