Forum Discussion

rajc's avatar
rajc
New Member
3 years ago

Remove row subtotals when matrix is collapsed.

Hi,

 

I am trying to build a matrix with row sub totals turned off.. but unfortuantely its working only when the selected group is drilled down.. if the group is collapsed its still showing avarage of the rows in the group. 

 

I tried turned off the Per row level for each Row level but still its only turning off when the items are expanded. when its collapsed its kepe showing the total (which I really don't need).. 

 

When Expanded. 

When Collapsed.

Row Subtotal settings. 

 

 

Also, tried turning off the Row subtotals al together and still its showing the average/total when its collapsed.. 

 

Please let me know if there is any workaround or known bug around this?

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    3 years ago

    HI rajc ,

     

    That's just how the matrirx behaves. You need to specify in your measure which value or when a value is to be shown. Try this:

     

    =
IF ( HASONEVALUE ( 'table'[column] ), [measure] )

     

    Replace column with the column for the  names. The measure will return blank if there are more than one names in the current filter context.

  • rajc's avatar
    rajc
    New Member
    3 years ago

    danextian Thanks for the response.

    Sorry unfortunately tried your suggestion but its not clear to me as using below measure showing blank in the names column. 

     

     

     

    Measure = If(HASONEVALUE(Sheet1[Name]), [Time1])

     

     

     

     

    This is the same data.