How to use Multiple totals in the Table

[Anonymous]

Hi Experts, 

I am new to Power BI desktop and struggling to achieve below. I need to insert Totals for Country, Dept and Release manager as shown in the below table. Please help!

Total Line	Cust Name	Cust Number	Faculty Amt	Outstanding Amt
Total for Country: USA			1300	300
Total for Dept: DEPT-1			700	200
Total for Rel manager: RM-11			400	100
TL0001	Cust01	111	100	50
TL0002	Cust02	222	200	10
TL0003	Cust03	333	100	40
Total for Rel manager: RM-12			300	100
TL0004	Cust04	444	100	80
TL0005	Cust05	555	200	20
Total for Dept: DEPT-2			600	100
Total for Rel manager: RM-21			600	100
TL0006	Cust06	666	400	90
TL0007	Cust07	777	200	10

[Tahreem24]

@Anonymous ,

You can use the Matrix visual to achieve your requirement.

[Anonymous]

Thanks so much @Tahreem24 @nandukrishnavs 🙂

[nandukrishnavs]

@Anonymous 

Refer to this : https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[speedramps · Accepted solution]

Hi Negi

Please consider this solution ....

Dont use the table visualisation tool.  Try using the matrix visualisation tool next door instead.

The matrix has a subtotal option in the format (pain roller) menu.

[Anonymous]

Many thanks @speedramps 🙂