Not displaying the sub levels if only one sub level in Matrix visual

[Arshadjehan]

Hi, 

Matrix visual as shown below , displays the sub level details even if there is only one sub level. 

I want to hide the sub level if there is only one sub level, in this case to display only upto "Provincial" level , coz values is same in only one sub level i.e. "ADP (Provincial)"

Any Help ?

[v-frfei-msft · Accepted solution]

Hi @Arshadjehan ,

Sorry for misunderstanding your request. Here we cannot filter the matrix directly, we can create measure to work on it.

sum of be = 
VAR dis =
    DISTINCTCOUNT ( 'Table'[sub2] )
var be = SUM('Table'[BE])
var a = IF(dis = 1
            && ISINSCOPE ( 'Table'[sub2] )
            && OR (
                SUM ( 'Table'[Release] )
                    = CALCULATE ( SUM ( 'Table'[Release] ), ALL ( 'Table'[sub2] ) ),
                SUM ( 'Table'[Release] ) = 0),TRUE())
var  b = 
IF(dis = 1
            && ISINSCOPE ( 'Table'[sub2] )
            && OR (
                be
                    = CALCULATE ( be, ALL ( 'Table'[sub2] ) ),
                be = 0),TRUE())


RETURN
    IF (
        a&&b,
        BLANK(),be
        
    )

For more details, please check the pbix as attached.

[v-frfei-msft]

Hi @Arshadjehan ,

Please enable the option "show items with no data " for the rows in your matrix visual.

[Arshadjehan]

@v-frfei-msft  I probably couldnt make you understand what I want!

I want to hide the sub level, if there is only one sub level, and to show as parent level only.