cancel
Showing results for
Did you mean:
Frequent Visitor

## count child hierarchy based on parent

Hi,

I have created hierarchy structure and count all the child of parent hierarchy.

Diagram:

1
/  \
2     3
/ |\    /\
4 5 6  7 8
/\     /\
9 10  11 12

From the above diagram I need if I select parent "2" then I need to count total Number of child below of "2"(Example: 4,5,9,10 and display count as  4. Note: don't select  parent "6" bacause parent "6" has child 9,10) .

Table structure:

 Projectkey ParentKey Path length 1 1 1 2 1 1|2 2 3 1 1|3 2 4 2 1|2|4 3 5 2 1|2|5 3 6 2 1|2|6 3 7 3 1|3|7 3 8 3 1|3|8 3 9 6 1|2|6|9 4 10 6 1|2|6|10 4 11 8 1|3|8|11 4 12 8 1|3|8|12 4

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super Contributor

## Re: count child hierarchy based on parent

Hi @abhishek646,

Based on my test, you could refer to below stpes:

Calculate a calculated column:

`Column 3 = PATHITEM('Table1'[Path],2,1)`

Create below measure:

`Measure 2 = CALCULATE(COUNT(Table1[ParentKey]),FILTER(ALL('Table1'),'Table1'[Column 3]=SELECTEDVALUE('Table1'[ParentKey])&&'Table1'[length]<=3))`

Result:

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super Contributor

## Re: count child hierarchy based on parent

Hi @abhishek646,

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Super Contributor

## Re: count child hierarchy based on parent

Hi @abhishek646,

Based on my test, you could refer to below stpes:

Calculate a calculated column:

`Column 3 = PATHITEM('Table1'[Path],2,1)`

Create below measure:

`Measure 2 = CALCULATE(COUNT(Table1[ParentKey]),FILTER(ALL('Table1'),'Table1'[Column 3]=SELECTEDVALUE('Table1'[ParentKey])&&'Table1'[length]<=3))`

Result:

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super Contributor

## Re: count child hierarchy based on parent

Hi @abhishek646,

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 108 members 1,090 guests
Recent signins: