How to hide some total value in table for some column?

kmkwongaa , You can hide for subtotal or total completely.

or create a measure that does not display total

example

measure new = if(isfiltered(Table[Defect Status],[Measure],blank())

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

Hi kmkwongaa 

Create measures

Measure 2_no =
CONVERT (
    IF (
        SEARCH ( "-", MAX ( 'Table'[no] ), 1, 0 ) >= 1,
        MID ( MAX ( 'Table'[no] ), 2, SEARCH ( ")", MAX ( 'Table'[no] ), 1, 0 ) - 2 ),
        MID ( MAX ( 'Table'[no] ), 3, SEARCH ( ")", MAX ( 'Table'[no] ), 1, 0 ) - 3 )
    ),
    INTEGER
)


Measure 2 = IF(ISINSCOPE('Table'[cate]),[Measure 2_no], SUMX('Table',[Measure 2_no]))

Measure 3_n2 =
CONVERT (
    IF (
        SEARCH ( "-", MAX ( 'Table'[n2] ), 1, 0 ) >= 1,
        MID ( MAX ( 'Table'[n2] ), 2, SEARCH ( ")", MAX ( 'Table'[n2] ), 1, 0 ) - 2 ),
        MID ( MAX ( 'Table'[n2] ), 3, SEARCH ( ")", MAX ( 'Table'[n2] ), 1, 0 ) - 3 )
    ),
    INTEGER
)


Measure 3 =
IF (
    ISINSCOPE ( 'Table'[cate] ),
    [Measure 3_n2],
    SUMX ( 'Table', [Measure 3_n2] )
)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.