Forum Discussion

cmiecz's avatar
cmiecz
New Member
2 years ago
Solved

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 /...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.