Forum Discussion
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],"|")
But unable to get the calculate sum values.
Pls. kind support to get the calculated values same as Relation logic. but should be sum calculation.
Below should be same as the results column values.
| Child | Parent | Value | Relation | Results |
| 2001 | 2002 | 10 | 2001 | 10 |
| 2002 | 2003 | 15 | 2001|2002 | 25 |
| 2003 | 2004 | 20 | 2001|2002|2003 | 45 |
| 2004 | 2005 | 25 | 2001|2002|2003|2004 | 70 |
| 2005 | 2006 | 30 | 2001|2002|2003|2004|2005 | 100 |
| 2006 | 2007 | 35 | 2001|2002|2003|2004|2005|2006 | 135 |
| 2007 | 2008 | 40 | 2001|2002|2003|2004|2005|2006|2007 | 175 |
| 2008 | 2009 | 10 | 2001|2002|2003|2004|2005|2006|2007|2008 | 185 |
| 2009 | 15 | 2001|2002|2003|2004|2005|2006|2007|2008|2009 | 200 | |
| 2010 | 2011 | 20 | 2010 | 20 |
| 2011 | 25 | 2010|2011|2012|2013|2014|2015|2016 | 245 | |
| 2012 | 2011 | 30 | 2012|2013|2014|2015|2016 | 200 |
| 2013 | 2012 | 35 | 2013 | 35 |
| 2014 | 2012 | 40 | 2014 | 40 |
| 2015 | 2012 | 45 | 2015|2016 | 95 |
| 2016 | 2015 | 50 | 2016 | 50 |
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])
8 Replies
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 , Awesome. It works as expected. Thanks.
lbendlin , hi again, i use the same code to count the values
ResCount =var c = SELECTEDVALUE('Table'[Child])var a= SUMMARIZE(ALLSELECTED('Table'),[Value],[P])var b= ADDCOLUMNS(a,"inc",IF(PATHCONTAINS([P],c),[Value]))return COUNTX(b,[inc])can you help me to count only the values that is more than zero or not null values on the column Value.