Forum Discussion

Anno2019's avatar
Anno2019
Icon for Helper IV rankHelper 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
      Icon for Community Support rankCommunity 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
        Icon for Administrator rankAdministrator
        2 years ago

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