Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Issues Using PATH Function with Multiple Root Nodes in Product Hierarchy

Hi everyone, I'm working with a product hierarchy in Power BI using the PATH function to model parent-child relationships. The challenge I'm facing is that I have multiple root-level products (i.e.,...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

     

    Thanks for confirming. You're correct, since PATH() requires a strict one-parent-per-child hierarchy, it won’t work for scenarios like yours with many-to-many relationships. Exploring alternatives like bridge tables or custom logic is the right direction.

     

    Thank you.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi DataNinja777 , thx ! I tried to do it but I got the following error :

"Each value in 'Final to path'[ps_comp] must have the same value in 'Final to path'[ps_par]. The value '424000050' has multiple values."

 

the value 424000050 indeed has 5 parents, its a product that can be a part of many products, does it means I cant work with PATH?