Forum Discussion

rbreneman's avatar
rbreneman
Helper II
5 years ago
Solved

Help with measures to hide data based on filter selection

Hi! I've tried this two different ways and I would expect both to work but that is not the case. Can someone help me figure out why the IsFiltered option isn't responding the way I would expect?   ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi, rbreneman ;

    Please try to create a new table and establish a relationship：

    new = SUMMARIZE('BOCES and N/RC',[DISTRICT_SHORT_NAME])

    and create a ralationship:

    then create a measure:

    IsFiltered = IF(ISFILTERED(new[DISTRICT_SHORT_NAME]),1,0)

    The final output is shown below:

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
5 years ago

Hi, rbreneman ;

Please try to create a new table and establish a relationship：

new = SUMMARIZE('BOCES and N/RC',[DISTRICT_SHORT_NAME])

and create a ralationship:

then create a measure:

IsFiltered = IF(ISFILTERED(new[DISTRICT_SHORT_NAME]),1,0)

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • rbreneman's avatar
    rbreneman
    Helper II
    5 years ago

    Hi v-yalanwu-msft,

     

    That worked! Thank you, thank you, thank you!! I won't pretend to understand why it needed to be done this way (using a new table) but it works and that is all that matters!

     

    I greatly appreciate your help!

    Ryan