Roll up child items count and display count at Parent

[nagaraj]

Hello,

 I have a below scenario where in have a Parent - Child relationship.

For the PARENT along with the name i need to display the count of CHILD  as 

 PARENT - (2)  

Regards

Nagaraj

[v-frfei-msft]

Hi @nagaraj ,

Based on my research, it is not supported yet currently. You can come up a new idea and add your comments there to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

[nagaraj · Accepted solution]

Able to resolve the above by writing below DAX in the table

Prop_Count =

CALCULATE(

COUNT(Table[hStatus]),

Table[isDeleted] = FALSE(),Table[Disp_Year] = YEAR(TODAY()) || Table[Disp_Year] = YEAR(TODAY())+1

)

[amitchandak]

Where you want to display

[nagaraj]

Hi,

 Need to display the child item count as shown below

Regards

Nagaraj

[amitchandak]

I do not think, I still got it. Best of matrix display, you can explore here

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/