Hide value and subtotals row from matrix

[SoufTC]

I have a data which appears as following :

 

 

I’m having trouble to hide from matrix values in yellow.

First, hide value and keep it just in subtotals. (data)[Evolution 180j]

Second, hide (data)[LAST %180j] from subtotals.

 

I tried this as a calculation for the measures :

Evolution 180J = SWITCH( TRUE(),
                         ISINSCOPE(data[SITE]) && ISINSCOPE(data[date]),
                         BLANK(), [LAST % 180 j] - [First % 180 j] )


Last 180j = CALCULATE (SUM (data[180 j]) , 
                          LASTNONBLANK( data[date], sum(data[180 j]) ))

Please, any help?

Thank's in advance

[v-yanjiang-msft]

Hi @SoufTC ,

For Evolution 180J, can only appear blank as shown, but not completely hide them. For LAST %180J, you can use the same function ISINSCOPE to display blank in the subtotal.

Last 180j =
IF (
    ISINSCOPE ( data[date] ),
    CALCULATE (
        SUM ( data[180 j] ),
        LASTNONBLANK ( data[date], SUM ( data[180 j] ) )
    ),
    BLANK ()
)

You can only show them blank, but not remove/hide them, it's by design.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.

[SoufTC]

@v-yanjiang-msft thank you for your answer but I need to hide them and not show them blank...