Collapsed Matrix to Show Blanks Using Measure Names

[Anonymous]

Hello,

I am trying to show blanks for my collapsed matrix visual rather than visuals. I understand that can be done using ISINSCOPE, however the column I'm trying to show blanks for is based off of a measure. Can anything be done?

Thank you in advance.

[Anonymous]

Hello,

I have similar issue where in i am using info river visual for matrix view. I have a mtrix with sub filters upto 3 levels. I want each level to display a defined static number when collapsed rather than in built sum up by the tool.

As given in the screenshot , there's main level which when collapsed shows 865 and under the filter i have sub level filter as radio/connected devices etc which has its own statement under them with different values. I want to display static number for connected devices eg 750 instead of aggregating the total value based on statement under the filter. So basically connected devices to show 750 ,radio 150 etc when collapsed.

Is there anyway i can achieve this? column field is Number & Percentage based.

Thanks in advance.

[amitchandak]

@Anonymous , You can check like

if(isinscope(Table[Column]) && isblank([Measure]) , <>, <> )

[Anonymous · Accepted solution]

Hi @amitchandak,

Thank you so much for the response! It doesn't quite work, and I probably should have been more specific with my question. I wanted a measure that would show blanks rather than values for the collapsed matrix. (Refer to below image)

However, when the matrix is exanded, I didn't want those values to also be blank. (Refer to the below image. Also, please imagine the crossed out values are populated. The info is sensitive, so I couldn't just leave it there.)

Maybe I did something wrong, but when I input the measure with my fields, both the expanded and collapsed matrix values show up as blank. However, it was a great hint that led me in the right direction.

The solution I came up with is as follows:
IF( ISINSCOPE( 'Table'[Column1]) && NOT( ISINSCOPE( 'Table'[Column2])), BLANK(), [Measure])

 *As a side note for anyone else needing help with this, column1 is from the first value in the row field of the matrix, and column2 is the second value in the row field of the matrix. The measure is the original measure that originally didn't have the blanks in the collapsed matrix.