Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

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

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 ?

1 ACCEPTED SOLUTION
Community Support

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.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
3 REPLIES 3
Community Support

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.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Community Support

Hi @Arshadjehan ,

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Helper I

@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.

## Helpful resources

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors