Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I am working on a requirement where I have to establish multiple Hierachies.
Example:
Key | Parent1 Key | Parent2 Key |
324 | 324 | 19700 |
325 | 324 | |
326 | 324 | |
327 | 324 | |
328 | 328 | 19400 |
329 | 328 | |
330 | 328 | |
331 | 331 | |
332 | 331 | |
333 | 331 | |
Table 2 | ||
Key | Hours | |
324 | 100 | |
325 | 200 | |
326 | 100 | |
327 | 100 | |
328 | 100 | |
329 | 100 | |
330 | 100 | |
331 | 100 | |
332 | 100 | |
333 | 100 |
In the above table Parent1 key is the immediate parent of Key column and Parent2 key is the parent of parent1. The requiremnt is to get all the keys associated with Parent 2 and get the total hours for them. I have tried using multiple measures and functions like path but i am not getting the correct result. Can you please help me get the summed up hours on the basis of Parent 2 keys.
Solved! Go to Solution.
Hi @Kish1999 ,
What is the Parent key2 in the blank values? If your hierarchy is like this:
You can create a the Hierarchy in Matrix visual directly, please try:
First, build the relationship between the two tables:
Then add the key columns to the rows field:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Kish1999 ,
What is the Parent key2 in the blank values? If your hierarchy is like this:
You can create a the Hierarchy in Matrix visual directly, please try:
First, build the relationship between the two tables:
Then add the key columns to the rows field:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
82 | |
55 | |
39 | |
20 | |
12 |