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

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
5 years ago

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.