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

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
Icon for Community Champion rankCommunity 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.. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    the relation is right, but the calculated value is wrong.

     

    the formula i have is below but shows wrong ouptut.

    CalValue = SUMX(FILTER('ParentChild',PATHCONTAINS(EARLIER('ParentChild'[Tree]),'ParentChild'[Child])),'ParentChild'[Value])