Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Sounds like you want PATH
https://docs.microsoft.com/en-us/dax/path-function-dax
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
48 | |
25 | |
20 | |
14 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |