Forum Discussion

PCHMarc67's avatar
PCHMarc67
Frequent Visitor
2 years ago

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