hierarchy table with row counts

[Anonymous]

Hello, I am trying to make a visual look similar to a pivot table, with a count of each row. Right now, I have my table data in a matrix visualization and it looks like this:

I want the visual to pull subtotals for each of the 6 row headers and do a total count at the bottom. Is there a custom visual I can use for this, or a way I can force totals to show up?

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Based on your description, I have created a simple sample:

Since I don't know your original measure, you could replace [Your Original Measure] in the DAX with your original measure:

Measure = IF(ISINSCOPE('Table'[Category 2]),[Your Original Measure],COUNT('Table'[Category 2]))

Final output:

Best Regards,

Jianbo Li

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

[Anonymous]

 

specifically hoping to get a visual to look something like this