Forum Discussion
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...
danextian
Super User
Super UserHI 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.