Forum Discussion
Slicer value for calculation
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)
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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! 🤠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.
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
