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 percentage from 0.01 to 0.5 "Which the user can adjust with a slicer".  The slicer uses a table GENERATESERIES(0, 1, 0.01)

[selected %] is calculated with this formula selected % = SELECTEDVALUE('Parameter'[% value], 0.1)

[sales] = no calculation, this is the value of the sales in USD

 

Here is the problem.  I would like to use [Multiple Fruits] as a filter, would like the user to be able to choose "Only One" and see records only relating to "Only One".

I tried to create a column with the same calculation with no success.

 

Does anyone know how I could achieve this?

 

 

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.

4 Replies