Forum Discussion

teng1's avatar
teng1
Frequent Visitor
3 years ago
Solved

Disable matrix summarized total

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. How...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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())

amitchandak's avatar
amitchandak
Super User
3 years ago

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's avatar
teng1
Frequent Visitor
3 years ago

Hi amitchandak,

Thanks for showing the direction.

 

Here is what works for me.

Previously i made a mistake on the lowest level measure.

 

Regards.