Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

drill down hierarchy and INSCOPE

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...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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.