cancel
Showing results for
Did you mean:
Regular Visitor

## ISINSCOPE help to delete row

Hello!!

I have an issue with the use of ISINSCOPE function,  I hope someone could help me!

I want to remove the blank level of the hierachies, and im using some measures for this, but when delete the row, the next level is deleted too, and I dont want to delete.; only want to delete the level in blank.

Im included the example in the pbi file.

example pbi

Thanks for the help.

Monica

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: ISINSCOPE help to delete row

Just try this formula as below:

```Measure =
IF (
IF ( ISINSCOPE ( Sheet1[GROUP_TYPE] ), 1, -1 )
* IF ( ISINSCOPE ( Sheet1[DESC] ), 1, -1 ) = -1
&& SELECTEDVALUE(Sheet1[GROUP_TYPE]) = BLANK (),
BLANK (),
SUM ( Sheet1[VALUE] )
)```

Result:

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Senior Member

## Re: ISINSCOPE help to delete row

From your Power BI File, I used a basic table to understand your question better

From this photo, you can see the blanks coming from Group_Type.

If you will hide it, it will also affect the columns with it.

For the workaround, You can substitute the blanks with other values or texts.

Community Support Team

## Re: ISINSCOPE help to delete row

Just try this formula as below:

```Measure =
IF (
IF ( ISINSCOPE ( Sheet1[GROUP_TYPE] ), 1, -1 )
* IF ( ISINSCOPE ( Sheet1[DESC] ), 1, -1 ) = -1
&& SELECTEDVALUE(Sheet1[GROUP_TYPE]) = BLANK (),
BLANK (),
SUM ( Sheet1[VALUE] )
)```

Result:

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

## Re: ISINSCOPE help to delete row

Thanks for the help.

Greetings

Announcements

Kudos to you if you earned one of these! Check your inbox for a notification.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (1,314)