The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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)
Solved! Go to 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.
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.
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.
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! 🤠