Subtotals for single row in Power BI Matrix

[binayjethwa]

Hi , 

 I there any possible way we can show total for a single row only when we have multiple values in row section in matrix visual.

For Example as below , Is thre any way i can enable subtotals and display as below , just one row of total for all the Rows in the matrix .  This is just a sample data , i can have multipne empoyees , Categories , locations under a each Employee also .

Please suggest if this is achievable in power bi matrix , if not what would be alternative .

Note: Here date is weekly data so it will be 52 weeks.

If i enable row subtotals , it will enable for each row and i see totals for all the fields which are present in rows in my matrix which i dont want.

Emp No	Name	Country	Location	Category	07-Aug	14-Aug	21-Aug	28-Aug
133	Binay	India	Hyderabad	Cat1	12	12	122	33
134	Binay	India	Hyderabad	Cat 2	11	13	123	34
135	Binay	India	Hyderabad	Cat 3	11	14	124	35
136	Binay	India	Hyderabad	Cat 4	34	15	125	36
				Total	68	54	494	138
133	Binay1	India	Hyderabad	Cat1	12	4	122	33
134	Binay1	India	Hyderabad	Cat 2	3	13	33	34
135	Binay1	India	Hyderabad	Cat 3	11	14	124	35
136	Binay1	India	Hyderabad	Cat 4	34	15	125	36
				Total	60	46	404	138

Thanks,

Binay

[binayjethwa]

Hi @Idrissshatila ,

I need a separate totals column for each employee and their sum up values based on multiple categories in a single row. Grand total will give for entire table rows, i need it separately for each row item, 

[Idrissshatila]

HEllo @binayjethwa ,

you should enable the grand total column which sums everything and show their total.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin