Remove one total from matrix

[aritz001]

Is there a way I can just remove the total in the red box?

[danextian · Accepted solution]

Hi @aritz001 ,

You have to write a measure that will do that. Below is just a sample for illustration and data might not make sense but achieves removing the total for a particular column  item. Replace Dates[Month Name] ) = "July" with your column field and NOT ( HASONEVALUE ( Dates[Date] ) ) with your row field.

Remove total for July =
IF (
    SELECTEDVALUE ( Dates[Month Name] ) = "July"
        && NOT ( HASONEVALUE ( Dates[Date] ) ),
    BLANK (),
    COUNT ( Dates[Month Short] )
)

As you can see below, the total is removed for July but  the rows still have the numbers.

[aritz001]

Here is the current formula and having issues doing what you did 

Total Staff Count = SUMX(SUMMARIZE('tblTimeCombined_TimeDetail',
'tblTimeCombined_TimeDetail'[Date],"count", DISTINCTCOUNT ( 'tblTimeCombined_TimeDetail'[Staff ID] ) ),[count])

[Len_Barr]

As far as I know, you can't