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 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
Super User
Super UserHi 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