Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
cmiecz
New Member

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)

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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]

vkongfanfmsft_0-1709796183375.png

vkongfanfmsft_1-1709796195559.png

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.

 

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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]

vkongfanfmsft_0-1709796183375.png

vkongfanfmsft_1-1709796195559.png

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
New Member

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
Super User
Super User

@cmiecz 

 

under modelling tab, 

create a table using the enter manually  feature : 

Daniel29195_2-1709675149138.png

 

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

Daniel29195_3-1709675187171.png

 

 

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! 🤠

 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.