How to establish Hierarchy in case of Multiple hierarchies

[Kish1999]

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.

[v-jianboli-msft · Accepted 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.