Remove totals and sub-totals for some columns in a matrix

[anmdf]

Hi Power Bi community,

I wanted to remove totals and sub-totals for some columns in my matrix (Analysis columns, see below). I saw some posts on here, like ISFILTERED and HASONEVALUE, but it doesn't seem to work for me? Could you kindly direct me to the right solution?

Description	Period A Amount	Period B Amount	Period A Analysis	Period B Analysis
+ Category 1	11	15	AAA	CCC
A	5	7	AAA	CCC
B	6	8	BBB	DDD
+ Category 2	15	19	XXX	YYY
C	7	9	XXX	YYY
D	8	10	ZZZ	WWW
Total	26	34	AAA	CCC

Here are the measures for the columns:

Period A Amount = CALCULATE([Amount], USERELATIONSHIP('Calendar - Period A'[Date], Database[Date]))

Period B Amount = CALCULATE([Amount], USERELATIONSHIP('Calendar - Period B'[Date], Database[Date])) 

Amount = SUM(Database[Value])

Period A Analysis = CALCULATE(MAX(Database[Analysis]), USERELATIONSHIP('Calendar - Period A'[Date],  Database[Date]))

Period B Analysis = CALCULATE(MAX(Database[Analysis]), USERELATIONSHIP('Calendar - Period B'[Date],  Database[Date]))

Thank you!!

[aj1973]

Hi @anmdf 

Turn off subtotals, Row and Column 

[anmdf]

Hi @aj1973 ,

Thanks for the response. However, I don't have this option for column yet, my organization is still in the October 2020 version. As for turning of the row subtotal, it would turn off all the totals and subtotals, but I only want that for two of my columns (the analysis ones).

[v-yiruan-msft · Accepted solution]

Hi @anmdf ,

As @aj1973 suggested, you can make some setting in Format pane to decide which field display the subtotal. Please refer the solution in the following thread to achieve it.

How to remove sub column total from matrix

1. Select the related visual

2. Navigate to Format pane and find Subtotals tab

3. Toggle the option "Per column level" on and turn off these analysis fields 

Best Regards

[anmdf]

Hi @v-yiruan-msft 

What version are you currently using? Currently I'm not able to apply the solution to only one column (Oct 2020 version), it removes subtotal for the whole row. I only want to remove the ones in red below.

So far I did field formatting and made the subtotals white in font, but I was wondering if there was a cleaner way to do it.

[v-yiruan-msft]

Hi @anmdf ,

The version of my Power BI Desktop is 2.94.921.0 64-bit (June 2021), you can try to update your Power BI Desktop to this version. Later check whether it can resolve the subtotal problem after upgraded.

Best Regards