Would like create report that will show the Multiple Parent Apps and its dependencies.

[jocjocrl2025]

Data contains multiple parent applications and dependencies. Some of the parent applications are part of dependencies of another parent applications.  Not sure if its possible, i'm having trouble using Path function.  I hope someone can help.

Here's a sample data.

Parent App ID	Parent App	Child App ID	Dependent App
4	Aruba	2	Amer
2	Amer	7	Am1
2	Amer	1	Global
1	Global	6	G1
1	Global	10	G2
1	Global	11	G3
5	Ph	9	Ph_Ap
5	Ph	3	Apac
3	Apac	8	Ap1
3	Apac	1	Global

[FBergamaschi · Accepted solution]

PATH assumes there is only one parent for each child

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[speedramps]

@jocjocrl2025 

Thnaks for the thumbs up, please can you also click [accept the solution].

Incidentally, I forgot to mention you need to create records for each 'entity'.

In yout example Aruba and Ph were missing, which will generate a error message.

I have added them in my example and the PATH works ok.

[speedramps · Accepted solution]

Hi @jocjocrl2025 

Your data is invalid

Global is not allow to have two parents

If you remove one of like this 

Then add a New Column

Path = 
PATH(yourtable[Entity ID],yourtable[Parent ID])

The hierachy then works ok

Learn more abour hierachies here ..

https://learn.microsoft.com/en-us/dax/understanding-functions-for-parent-child-hierarchies-in-dax

https://www.youtube.com/watch?v=EzfLJFEKV8I

Please clik thumbs up because I have tried to help.

Then click [accept solution] if it works.  (it will work 😀)

Thank you

[FBergamaschi · Accepted solution]

PATH assumes there is only one parent for each child

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[jocjocrl2025]

@FBergamaschi  I think this answer my question.  I can't used Path Function for the data that I need to output. As my data has multiple parents apps connected to child.

@speedramps, also points out that my data is invalid.

Any tips or tricks that I can used besides path function.

[speedramps]

@jocjocrl2025 

Thank you for accepting the solution.

The PATH and other heirachy coimmands are the best method in Power BI.  There are no other "tricks".
You data just needs cleaning.

Each top node muct have a records.  (4 and5 were missing in your example).

Parents can have more than one child but a child can only have one parent.

Global can not have both Apac and Amer as a parent.

I suspect that this is a typing mistake because I would expect Global to be the top node 

and Apac and Amer to be geographic children of Global.

If a child has two or more parents then consider concatinating the parent names into one column e.g. Apac/Amer.

The PATH command will strill treat the row as single parent but you would know from the decsription that is was 2 parents.

However, it get more complex if parents "remarry" and have other children.

I recommend that you model your data to only allow one parent per child,

but allow parents to have multiple children, grandchildren and great grandchildren.

The PATH command is ideal for that.

Learn more abour hierachies here ..

https://learn.microsoft.com/en-us/dax/understanding-functions-for-parent-child-hierarchies-in-dax

https://www.youtube.com/watch?v=EzfLJFEKV8I

[FBergamaschi]

@jocjocrl2025  thanks to you

pls marka a solution all the posts that gave you the right indications, so other can take advantage of these

Thx