Forum Discussion

TaroGulati's avatar
TaroGulati
Icon for Helper III rankHelper III
4 years ago
Solved

IsInscope function issue

Hey Everyone,   I am having some issue with ISINSCOPE Function.    i have this simple table:     I am getting this as result:   I am using this measure:  measure = SWITCH(TRU...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi TaroGulati 

     

    You could try this measure

    NewMeasure = 
SWITCH (
    TRUE (),
    ISINSCOPE ( 'Table'[Third level] ),
        SWITCH (
            SELECTEDVALUE ( 'Table'[Third level] ),
            BLANK (), BLANK (),
            "", BLANK (),
            30
        ),
    ISINSCOPE ( 'Table'[Second level] ),
        SWITCH (
            SELECTEDVALUE ( 'Table'[Second level] ),
            BLANK (), BLANK (),
            "", BLANK (),
            20
        ),
    ISINSCOPE ( 'Table'[First level] ), 10,
    BLANK ()
)

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi TaroGulati 

 

You could try this measure

NewMeasure = 
SWITCH (
    TRUE (),
    ISINSCOPE ( 'Table'[Third level] ),
        SWITCH (
            SELECTEDVALUE ( 'Table'[Third level] ),
            BLANK (), BLANK (),
            "", BLANK (),
            30
        ),
    ISINSCOPE ( 'Table'[Second level] ),
        SWITCH (
            SELECTEDVALUE ( 'Table'[Second level] ),
            BLANK (), BLANK (),
            "", BLANK (),
            20
        ),
    ISINSCOPE ( 'Table'[First level] ), 10,
    BLANK ()
)

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.