using a measure as a report filter

[zanottiluca]

hi all, 

hope you are well. 
I have a somewhat strange question about a request from a client. 
In brief I have a whole report built on room attendance where the dataset is very granular: at every 15 minutes of an hour it shows if a room is occupied or not. Attached an example of two rooms and time between 8:00AM and 9:30 AM
I have built  my measures to calculate the % in the following way and the report does its jobs. The user can filter for different variables  (location/room data)and visualize the percentage overtime / by location etc.  

occupied block = sum('Main Data'[occupied])+0

total blocks = COUNT('Main Data'[time])+0

% utilization = DIVIDE([occupied block],[total blocks])+0
However I have received the request to provide a report filter where the user want to see the same stats for the rooms booked over 80% utilization. In brief using the above measure to filter the whole report and I am struggling a bit to find this way . I believe measure can be used only in Viuals as filters and also due to granularity of the data it seems a bit difficult. 

Hence I am seeking your help or advice if you can? 

Thanks 
Luca

[Martin_D]

You could replace the measures in your visuals by measures that only return a value if utilization is >80%. Otherwise the measure returns blank and the rooms disappear.

occupied block >80% = IF ( [% utilization] > .8, [occupied block] )

total blocks >80% = IF ( [% utilization] > .8, [total blocks] )

% utilization >80% = IF ( [% utilization] > .8, [% utilization] )

[Martin_D]

If you want to have this dynamic, with a report level filter, you can create a what-if parameter, put the parameter in the report level filter, an replace .8 with the parameter value in the formulas.
I'd create a parameter 0..100, step 1, default -1 and replace .8 with DIVIDE([Parameter Value], 100)