Forum Discussion

Anno2019's avatar
Anno2019
Helper IV
4 years ago
Solved

Use measure result as filter

Hi Guru's Seems like such a small thing, I however keep failing.   I have a measure: Multiple Fruits =if('table1'[sales]>'Parameter'[selected %],"Only One","More than One")   [selected %] =a pe...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi， Anno2019 

    Please try the following steps:

    1.Enter a new table ’Slicer‘ as below and apply it to slicer:

    2. create a filter measure

    filter = IF('Table'[Multiple Fruits] in VALUES(Slicer[Multiple Fruits]),1,0)

    3. drag this measure to table visual filter pane

     

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

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi， Anno2019 

Please try the following steps:

1.Enter a new table ’Slicer‘ as below and apply it to slicer:

2. create a filter measure

filter = IF('Table'[Multiple Fruits] in VALUES(Slicer[Multiple Fruits]),1,0)

3. drag this measure to table visual filter pane

 

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

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

It works perfect thank you very much! It's just what I was needing to do.