Slicer value for calculation

[cmiecz]

 I have a formula determining team utilization and want to use a slicer to insert a value of 0,5,4,3,2,1 into the calculation to reduce the overall work hours.

Utilization = sum of booked hours / workableHrs

workableHrs = sum of workable hours - slicer value (0,5,4,3,2,1)

[Anonymous · Accepted solution]

Hi @cmiecz ,

You should create a slicer table and try formula like below:

workableHrs = SUM(YourTable[Workable Hours]) - SELECTEDVALUE(SlicerTable[SlicerValue])

Utilization = SUM(YourTable[Booked Hours]) / [workableHrs]

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cmiecz]

Thanks for the response.

I have created a table with one column and my values as well as a slicer that I dragged the column values on it. Once I select a value form the slicer list my values are not adjusting. It is not seeing the slicer value.

[Daniel29195]

@cmiecz 

under modelling tab, 

create a table using the enter manually  feature : 

create a slicer visual and drag and drop the column to it .

no in your code.  

use selectedvalue( created_table_name[col_name] , [defaultvalue]) 

NB : [defaultvalue] . in case you dont have w selection, the default value is used. 

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠