Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Remove Some subtotals from Matrix

  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...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

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