Remove Some subtotals from Matrix

[Anonymous]

Hi I would like to remove some subtotals from a matrix table, like this:

I tried with this formula, but something is missing from it:

MTD =

IF(

    ISINSCOPE(CanalGrup[Canal 2]),

    IF(

        ISINSCOPE(CanalGrup[Canal 2])=BLANK(),

        IF(ISINSCOPE('dw_si DimChain'[Chain]), IF(SELECTEDVALUE(UnitateMasura[Tip])="Value",TOTALMTD( SUM('dw_si FactSI'[TotalValue]),'Calendar'[Date]),TOTALMTD( SUM('dw_si FactSI'[Quantity]),'Calendar'[Date])),BLANK()),

        IF(SELECTEDVALUE(UnitateMasura[Tip])="Value",TOTALMTD( SUM('dw_si FactSI'[TotalValue]),'Calendar'[Date]),TOTALMTD( SUM('dw_si FactSI'[Quantity]),'Calendar'[Date]))

    ),

    IF(SELECTEDVALUE(UnitateMasura[Tip])="Value",TOTALMTD( SUM('dw_si FactSI'[TotalValue]),'Calendar'[Date]),TOTALMTD( SUM('dw_si FactSI'[Quantity]),'Calendar'[Date]))

)

Thank you!

[Anonymous]

The problem is that I have to crate another channel named: "Direct Secom", which is a total of "LL Other", "Farmacii Independente" and "LL KA":

And the chain is from another table. 

So I have Level 1 Channel/Canal drilled down level 2, which is Chain for all level 1 except "Direct Secom", which has "LL Other", "Farmacii Independente" and "LL KA".

[Anonymous]

Thank you @tamerj1 

I tried your solution but nothing is happening 😐

[tamerj1]

Hi @Anonymous 
Please try
IF ( 
ISBLANK ( SELECTEDVALUE ( CanalGrup[Canal 2] ) ) && HASEONEVALUE ( CanalGrup[Canal 2] ),
BLANK ( ),
"The rest of the calculation...
)