Forum Discussion
leejoel
Helper I
Helper ICalculate %Overtime worked with SLICER
Hello, I need to calculate %OT worked and have that number be dynamic (changing around slicer selection). I know I could use =SUM(SCHED_OT_HRS) + SUM( UNSCHED_OT_HRS) / SUM TOTAL HRS but this gi...
This is the correct measure:
%OT Worked =
DIVIDE(
sum( T[sched_ot_hrs] ) + sum( T[unsched_ot_hrs] ),
sum( T[total_hrs] )
)and if your data looks like what you've posted, then since all the dates are the same, the measure will also be the same for any selection of dates if 1/1/2019 is among them. If not, the measure results in BLANK.
Best
D
leejoelHelper I
Helper IThis did the trick. Thank you very much!