Printing total by group

[ppgandhi11]

Hi, I am very new to Power Bi, Trying to learn. I need to print the total (sum) of counts by group. I am able to generate following output.

Code   Count  Total

A          5            5

A          7            12

A          3            15

B          4             4

B          6             10

So basically I am able to create a new measure called Total and print running total. However, I want to print something like this.

Code     Count

A              5

A              7

A              3

Total A    15

B              4

B              6

Total B    10

How can I achieve this in Power Bi? Any help is greatly appreciated. Thanks.

Prashant-

[v-yulgu-msft · Accepted solution]

Hi @ppgandhi11,

As a workaround, you can add an index column first (Query Editor mode -> Add column -> Index column).

Then, use a matrix visual to host data.

Best regards,

Yuliana Gu