Forum Discussion

aritz001's avatar
aritz001
Frequent Visitor
3 years ago
Solved

Remove one total from matrix

Is there a way I can just remove the total in the red box?  
Need Help
  • danextian's avatar
    danextian
    3 years ago

    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.

     

danextian's avatar
danextian
Super User
3 years ago

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's avatar
aritz001
Frequent Visitor
3 years ago

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])