ISINSCOPE help to delete row

[Anonymous]

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

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

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

[Anonymous]

Thanks for the help.

Greetings

[mussaenda]

Hi @Anonymous ,

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.