Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Parent Child Merge Calculation

I have a dax code the get the relationship for parent and child    Relation = CONCATENATEX(FILTER('Table',PATHCONTAINS(PATH('Table'[Child],'Table'[Parent]),EARLIER('Table'[Child]))),'Table'[Child]...
"DAX"
DAX&Power Query
  • lbendlin's avatar
    lbendlin
    2 years ago

    P is a calculated column

    P = path('Table'[Child],'Table'[Parent])

    Res is a measure

    Res = 
var c = SELECTEDVALUE('Table'[Child])
var a= SUMMARIZE(ALLSELECTED('Table'),[Value],[P])
var b= ADDCOLUMNS(a,"inc",IF(PATHCONTAINS([P],c),[Value]))
return sumx(b,[inc])
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

lbendlin hi again, below should be the output table in column Result_Count and Result_Sum

 

I also have an issue, error showing, if i change the child and parent value as text.

 

Is there's a way that instead of showing in column Relation as Child/Parent as number should be the child/parent name instead. Thanks again.

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Can you please post in a usable format?  I can't work with screenshots.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      lbendlin , pls. see shared link. 

       

      parent-child 

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        you can get rid of the errors by replacing missing parent names with nulls.

         

        I don't understand the logic behind your expected output columns. Please elaborate.