Use measure result as filter

[Anno2019]

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?

[amitchandak]

@Anno2019 , To me it seems like you need bucketing of a measure

I have done some work here

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

[Anno2019]

@amitchandak 

https://www.dropbox.com/s/0vtwucvl7po94et/Filter%20on%20dynamic%20measure.pbix?dl=0

I took the time to put this in a pbix file.

Hope the above link works.  I need to be able to use the [Multiple Fruits] as a filter.

[v-easonf-msft · Accepted solution]

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.