List eventual child ID knowing parent ID in a hierarchy

[AGo]

Hello,

I've got a parent-child table with calculated levels (in this case max depth is 4), eg. my first 34 rows, it's written in numbers but the type is text.

Parent	ID	Depth	Level 1	Level 2	Level 3	Level 4
11	11	1	11	0	0	0
11	12	2	11	12	0	0
11	13	2	11	13	0	0
11	14	2	11	14	0	0
11	15	2	11	15	0	0
12	16	3	11	12	16	0
12	17	3	11	12	17	0
12	18	3	11	12	18	0
12	19	3	11	12	19	0
16	20	4	11	12	16	20
21	21	1	21	0	0	0
21	22	2	21	22	0	0
21	23	2	21	23	0	0
21	24	2	21	24	0	0
21	25	2	21	25	0	0
22	26	3	21	22	26	0
22	27	3	21	22	27	0
22	28	3	21	22	28	0
22	29	3	21	22	29	0
26	30	4	21	22	26	30
31	31	1	31	0	0	0
225	230	4	217	218	225	230
225	231	4	217	218	225	231
225	232	4	217	218	225	232
236	237	2	236	237	0	0
236	238	2	236	238	0	0
236	239	2	236	239	0	0
236	240	2	236	240	0	0
236	241	2	236	241	0	0
237	242	3	236	237	242	0
237	243	3	236	237	243	0
237	244	3	236	237	244	0
237	245	3	236	237	245	0
242	246	4	236	237	242	246

I would like to create a calculated column that returns the child (grandchildren also and so on) ID list with concatenation, for each ID, of course only if the have descendants (if not it's blank).

I would then use this function in another measure like this CALCULATE(SUM(value);[id] in {PreviousCalculatedFunction}) in a table viz next to ID field.

Is it possible?

Thanks!

[Greg_Deckler]

Sounds like you want PATH

https://docs.microsoft.com/en-us/dax/path-function-dax