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.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    As far as I know, you can't

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