Row Count:How to get the Row Count of the Lower Hierarchy level on each parent hierarchy in Matrix V

[vyerva]

How to get the Row Count of the Lower Hierarchy level on each parent hierarchy in Matrix Visual as shown below screenshot:

[Kishore_KVN]

Hello @vyerva ,

Have you tried Row Sub Total option of the Matrix Visual? Let us know if it is not working will suggest some other way. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[vyerva]

Thanks for the Suggestion, Can you please help to get the count of Lower hierarchy rows which I have highlighted in the below screenshot (yellow colour).

[v-zhangti · Accepted solution]

Hi, @vyerva 

You can try the following methods.

Column:

New Continent = [Continent]&"("&CALCULATE(DISTINCTCOUNT('Table'[Country]),ALLEXCEPT('Table','Table'[Continent]))&")"

New Country = [Country]&"("&CALCULATE(DISTINCTCOUNT('Table'[State]),ALLEXCEPT('Table','Table'[Country]))&")"

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vyerva]

Hi Kishore,  thanks.. I tried already that.