How to show group counts and totals in table or matrix visual

[kadingo]

I'm still new to power BI and i'm really trying to deep dive into it so i'm not certain what is possible and what is not.

I have the following sample data.

Is there away i can display the total counts of a Parent grouped by Area and then give a break down of those counts by Sub_Area?

In the sample data above, i want the results to display like in the screenshoot below:

Is this possible in Power BI?, i would be happy with any visual that can do it, so i'm not limited to a matrix or table.

Also do not mind about the group line markers, i inluded them just to clarify my requirement but if they also can be achievable it still be nice.

[v-eachen-msft · Accepted solution]

Hi @kadingo ,

I think martix can meet your requirements.

You need to put "Sub_ Area" column in the value section and choose count.

Here is the visual for your reference.

[kadingo]

@v-eachen-msft  Is there away your solution can be modified to look like as in the screeshoot below?

[v-eachen-msft]

Hi @kadingo ,

It is close to your screenshot but not perfect.

I used ISINSCOPE() function to create the measure. Here is my test file for your reference.

[kadingo]

@v-eachen-msft I have gone with your first example, its more than good enough, thank you very much.

[amitchandak]

Use matrix visual or even the table visual. and use countrows() measures

measure = countrows(table1)

or
measure = calculate(countrows(table1))

You filter using slicer or formula

measure = calculate(countrows(table1),area="Area_AA")

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[parry2k]

@kadingo matrix visual will do it, put it all 3 column rows (basically it will create an hierarch) and drill down to the hierarchy at the lowes level, you can also change look and feel by turning step layout on/off on format pane.

On value section of matrix, add following measure

Total Count = COUNTROWS ( YourTable )