Remove row subtotals when matrix is collapsed.

[rajc]

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?

[rajc]

@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. 

[danextian]

Hi @rajc ,

That is to be used in a measure. What you did is calculated column which name is measure.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-tutorial-create-measures 

[danextian]

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.