How can I hide the values in matrix when it is collapsed?

[SLama]

Hello all, 

I am trying to create matrix view. When I have it expanded, value doesn't show at the top as expected however, when I collapse it I keep getting values. These value makes  no sense so would like to hide. I tried isinscope function but couldn't hide the values.  I would like to hide yellow highlighted data. Please note I have shown measure I am using: 

I calculated Measure 2 as 

Measure 2 = Sum(CAA_KPI_DATA[DATA])

Any help would be appreciated. 

Thank you, 

SL

[v-yanjiang-msft · Accepted solution]

Hi @SLama ，

According to your description, please modify the formula to:

Measure =
IF ( ISINSCOPE ( [KPIS_NAME] ), [Measure 2], BLANK () )

This will ensure the Topic to be blank not matter it's be collapsed or not.

Best regards,

Community Support Team_yanjiang

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

[vicky_]

Swap the ISINSCOPE() from your screenshot to use ISFILTERED([KPI_Name]) instead.

[SLama]

When i swapped isinscope wth isfiltered and (KPI_NAME) I got opposite of what I wanted. I get number when collapsed and blank when expanded and I lose all KPI names when expanded and only see topic.