Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 d...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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