topic Remove Some subtotals from Matrix in DAX Commands and Tips

Remove Some subtotals from Matrix

Anonymous — Fri, 12 Aug 2022 07:22:12 GMT

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

)

Thank you!

Re: Remove Some subtotals from Matrix

tamerj1 — Fri, 12 Aug 2022 07:52:51 GMT

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

Re: Remove Some subtotals from Matrix

Anonymous — Fri, 12 Aug 2022 08:07:44 GMT

Thank you tamerj1

I tried your solution but nothing is happening 😐

Re: Remove Some subtotals from Matrix

Anonymous — Fri, 12 Aug 2022 09:41:21 GMT

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".