PBI Dec 2021: Cannot add measure to a filter

[croberts21]

I'm still pretty new to PBI. I have Free PBI Desktop v2.100.1182 (64 bit free version Dec 2021) on Windows 10.

I'm created a measure which does what I need it to do. It produces a value of 1 or blank for each row in a matrix. So now I want to add the measure to a page filter, and show only matrix rows where this measure, ShowJobFlag2 is 1. But I have tried several ways to drag this measure to a filter with no luck.

I selected the visual, clicked once on the measure then dragged it to the page level filters and it didn't go in there, and there was no error message. I also clicked the 3 dot menu on the measure to add it to the page level filters and that didn't work.

I deselected all visuals (by clicking once on the page), clicked once on the measure, then dragged it to the page level filters and it didn't go there. I also clicked the 3 dot menu on the measure to add it to the page level filters and that didn't work.

Could this be a bug? Will newer versions of PBI fix this bug? Or are we not allowed to add a measure to a filter?

FYI here's the measure. Note that it uses aggregate functions. I wonder if that's an issue.

ShowJobFlag2 = If (not(isblank(SUM(Jobcost[EstHours]))) 
  && not(isblank(SUM(Jobcost[ActHours])))
  && not(isblank(SUM(Jobcost[EstCost])))
  && not(isblank(SUM(Jobcost[ActCost])))
,1)

I need this measure because in my matrix, I sum all job costs and hours, actual and estimated for each job. This is the only way I can see to show only jobs with EstCost, ActuCost, EstHours, ActHours of non-zero. 

Screenshot of what I have so far:

Thank you!

[amitchandak · Accepted solution]

@croberts21 , a measure can only be added to the visual level filter.

Else you have to create buckets

range

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

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

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