Disable matrix summarized total

[teng1]

Hi All,

May i know is it possible to disable the auto summarized total in a matrix visual ?

I know that when the rows are collapsed, matrix will automatically apply function Sum to the figures. However, in my report layout, the total up values are meaningless.

So, is it possible to delete the total when rows are collapse ? (delete as in to show nothing in the figure column)

To change from:

change to:

Thanks

Regards,

[amitchandak · Accepted solution]

@teng1 , You can disable subtotal and you use the per row option to disable particular subtotal

You can also control it using, isinscope

Switch(True(),

isinscope(Table[Lowset level]), [Meausre],

isinscope(Table[level 1]), [Measure 2],

isinscope(Table[level 2]), blank())

[teng1]

Hi amitchandak,

Thanks for showing the direction.

Here is what works for me.

Previously i made a mistake on the lowest level measure.

Regards.