Filtering or Slicing against a Calculated Field (or Measure) that keeps changing

[PCHMarc67]

Hi, 

First, I'm using the January 2022 version of BI if that matters.   I have a Table Visual that can be affected by various slicers, but the final result will be a list of Departments and their (sum) total individuals.  the total individuals field I can create either by summing the individual IDs field or using a measure to do the same.    What I want to be able to do is after the initial slicers are set and the table shows the results, I want to custom filter by the total individuals sum.  I can't hard code the number since 10 in one list could be low or it could be the top in another (as an example).  At least in my version, I can't put a Measure into a slicer or a Filter.    in essense, I guess I want to filter of an on-the-fly calculation.       Hope that makes sense - thanks for any  help.    Did I read that newer PBI version has some type of filter on the Visualizations tab?       Marc

[amitchandak]

@PCHMarc67 , if you want a slicer on measure try dynamic segmentation

examples

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

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

Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q

Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4