How to display Row level totals in the grid

[Swathi1]

I have posted sample data in below, here my question is I want to show each metric level legend and totals in the grid at the bottom(Row level). How can I achieve this requiremnt. If we add sub totals option in BI we can get totals but each metric level I am not getting.

Can any one please help me out.

Territory	Metric	3/1/2025	3/2/2025	3/3/2025	3/4/2025	Totals
A	Sales	3	4	5	7	19
	Profit	1	1	0	2	4
	Loss	0	0	2	0	2
B	Sales	4	2	6	9	21
	Profit	0	1	0	2	3
	Loss	0	0	2	0	2
C	Sales	3	5	4	3	15
	Profit	0	3	1	2	6
	Loss	1	0	0	0	1
Total	Sales	10	11	15	19
	Profit	1	5	1	6
	Loss	1	0	4	0

[v-pgoloju]

Hi @Swathi1.,

Just a gentle reminder  has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

Best,

Prasanna Kumar

[v-pgoloju]

Hi @Swathi1,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution  it helps others who might face a similar issue.

Warm regards,

Prasanna Kumar

[v-pgoloju]

Hi @Swathi1,

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful  this will benefit others in the community as well.

Best regards,

Prasanna Kumar

[v-pgoloju]

Hi @Swathi1,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Swap the Row Order like Put Metric first, then Territory in the Rows of the matrix.
This makes Metric the parent level, so its subtotals (totals across territories) will be shown.

Let us know if you need further assistance  we’re happy to help. If this addressed your query, please consider marking the response as an Accepted Solution so it can assist others in the community as well.

Thank you & Regards,
Prasanna kumar

[Swathi1]

Its not Helped, any other approach please.

[v-pgoloju · Accepted solution]

Hi @Swathi1,

Thanks for reaching out to the Microsoft Fabric Forum Community.

Power BI doesn't show child-level subtotals by default. 

but as an alternative You can check below solution

I’ve tried to reproduce the scenario using the DAX below. Please review and adjust it according to your data source. If the issue still persists, feel free to share more details, and we’ll be happy to assist further.

Unpivot the date columns in Power Query.

then create a measure like

MetricTotal =
IF (
SELECTEDVALUE('Table'[Territory]) = "Total",
CALCULATE(SUM('Table'[Value]), ALL('Table'[Territory])),
SUM('Table'[Value])
)

If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.

Best regards,
Prasanna Kumar

[Ashish_Excel]

Hi,

Not sure of whether the image is your raw data or your expected result.  Very clearly, show 2 tables - one being the raw input data table and the other being the expected result.

[Swathi1]

Hi, 

Territory	Metric	3/1/2025	3/2/2025	3/3/2025	3/4/2025	Totals
A	Sales	3	4	5	7	19
	Profit	1	1	0	2	4
	Loss	0	0	2	0	2
B	Sales	4	2	6	9	21
	Profit	0	1	0	2	3
	Loss	0	0	2	0	2
C	Sales	3	5	4	3	15
	Profit	0	3	1	2	6
	Loss	1	0	0	0	1
Total	Sales	10	11	15	19
	Profit	1	5	1	6
	Loss	1	0	4	0

What ever I have highlighted in RED color that is my challenge to show in the grid and remains everything populated from the Backend Table.

[Ashish_Excel]

That does not answer the question i asked in my previous post.