Forum Discussion
Filtering or Slicing against a Calculated Field (or Measure) that keeps changing
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
1 Reply
- amitchandak
Super User
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