Forum Discussion
Slicer value for calculation
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.
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! 🤠