Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Tree Calculation/Aggregated Values Matrix

im struggling to create a table parent and child tree relationship, i have a parent and child table, i wanted to calculate the values with respect to their root parents like a family tree   Chil...
Need Help
Tips and Tricks
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    Tree Relation=CONCATENATEX(FILTER(Data,PATHCONTAINS(PATH(Data[Child],Data[Parent]),EARLIER(Data[Child]))),Data[Child],"|")

    Calculated Values formula keeps no change.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

i modify my table to be able to have a unique child. can you help me to have a solution its either on DAX or power query. Thanks in advance

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
2 years ago

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    wdx223_Daniel , Great, this works fine. May i know if its possible as well to get all the total for all grand child/children

     

    ChildParentValueTree RelationCalculate Grand Child
    Site1Site210Site110
    Site2Site320Site2,Site120+10=30
    Site3Site415Site3,Site2,Site115+20+10=45
    Site5Site45Site55
    Site4Site620Site4,Site5,Site3,Site2,Site120+5+15+20+10=70
    Site6 100Site6,Site5,Site4,Site4,Site2,Site1100+20+5+15+20+10=170

     

    Thanks again.

    • wdx223_Daniel's avatar
      wdx223_Daniel
      Community Champion
      2 years ago

      Tree Relation=CONCATENATEX(FILTER(Data,PATHCONTAINS(PATH(Data[Child],Data[Parent]),EARLIER(Data[Child]))),Data[Child],"|")

      Calculated Values formula keeps no change.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Thanks . but i got a wrong computation on the calculated values..