Subtotals - different rules for different columns

[A_a_a]

Hi All,

I have a matrix table, with measures as values. Measures are calculated based on Places, but when I create the matrix table I want to show Councils as well.

Is there any possibility to show subtotals in some columns, and leave it empty in others?

Once I use this:

I can see all subtotals, not sure if there is a tool to split it or maybe I can add some information to the measure?

Please help.

G.

[v-zhangti · Accepted solution]

Hi, @A_a_a 

You can try the following methods.

Sample data:

Measure:

A = SUM('Table'[Value])

B = DIVIDE(SUM('Table'[Value]),CALCULATE(SUM('Table'[Value]),ALL('Table')))

Measure A = IF(HASONEVALUE('Table'[Type]),[A],BLANK())

Measure B = IF(HASONEVALUE('Table'[Type]),[B],BLANK())

Row total is always on. But Dax can control whether Total outputs blank or numeric.

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.

[A_a_a]

Hi @v-zhangti ,

this is perfect. Thank you!

[Ashish_Mathur]

Hi,

The measure of those 2 columns can be modified.  Share the download link of the PBI file.

[A_a_a]

Hi @amitchandak,

thank you for your reply.

If I use the function that you mentioned above I will see subtotals (on/off) for all columns.

My question is if I can have it on only for two columns as I showed in the picture above ( 2 - on, 2 off).

Thanks,

G.

[amitchandak]

@A_a_a , In subtotal you have an option for per row level, You can enable and disable subtotal once you use that