Matrix: change row subtotals label

[bharatis]

Hi Team,

I am not able to change matrix subtotal labels to something different than total. For example if my  category is the brand of a car, then subtotal by brand like Total Toyota, Total Nissan etc etc.

Please advise how to achieve this. I am using the latest desktop  Version: 2.118.621.0 64-bit (June 2023)

Kind Regards 

B

[v-eqin-msft]

Hi, @bharatis 

Can you show the output you expect in Excel?

Best Regards,

Community Support Team _Charlotte

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

[bharatis]

Dear Team,

Please refer to below output i would like to see in power bi.

		No of Car Sold
Toyota	Corrolla	5
	Axio	2
	Vitz	3
	Vitz RS	1
	Total Toyota	11
Nissan	Sentra	3
	Versa	2
	Altima	5
	Total Nissan	10
Total Sale		21

[v-eqin-msft · Accepted solution]

Hi, @bharatis 

You can try the following methods.

Sample data:

Measure =
IF ( HASONEVALUE ( 'Table'[Model] ),
    SUM ( 'Table'[Sales] ),
    "Total" & " "
        & SELECTEDVALUE ( 'Table'[Brand] )
        & CALCULATE ( SUM ( 'Table'[Sales] ), ALLEXCEPT ( 'Table', 'Table'[Brand] ) )
)

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

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

[bharatis]

Hi,

Thank you so much @v-eqin-msft:  Community Support Team _Charlotte

Kind regards 

Bharati