drill down hierarchy and INSCOPE

[Anonymous]

I have plotted a bubble map with following hieracy 

Now I want when a user drill down (using drill mode) a target value is changed. In this regard I created a measure : 

TT =

SWITCH(

TRUE(),

ISINSCOPE (Database[Area]),1 ,

ISINSCOPE (Database[Well Name]),2,

3

)

I was expecting that when a user enter the next level in the hierarcy ( area in this case), the value should be 1 and when a user drilled down to further down in the hierarcy ( well name), the value is 2 however when I plotted the values in the table  it is not showing me any thing it means that ISINSCOPE is not detecting new filter context of hierercy change. Can anyomne please help me 

[v-xiaotang]

Hi @Anonymous 

Have you solved your problem? If yes, kindly accept the answer helpful as the solution(Or kindly share your solution 😁). so the others can find it more quickly.

Or

if problem still persists, please let me know.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi there

I end up using HASONEVALUE() measure becasue I cant use ISFILTERED as I want to use 3 levels drill down hierarcy so I can use the last measure as ISFILTERED but the middle one can use HASONEVALUE

[v-xiaotang]

Hi @Anonymous 

you can use function ISFILTERED(),

TT = 
SWITCH(
TRUE(),
ISFILTERED('Table'[State]),1 ,
ISFILTERED ('Table'[City]),2,
3
)

but you need to put measure into the same visual.  if you want to put the measure into another visual, you need to click on the first visual to transfer context.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I doubt when drill down the above member is still is in scope.

Change the order and try

TT =
SWITCH(
TRUE(),

ISINSCOPE (Database[Well Name]),2,
ISINSCOPE (Database[Area]),1 ,
3
)

[Anonymous]

Nopes still didnt worked . It displays 3 value only as you can see the output shown in the screenshot of the table output below. This means it is not detecting any change in the hierarcy.