Filtering a measure on a minimum amount

[drinko]

I am doing a Labor Analysis report and pulling in timeclock data.  I am trying to capture the total hours worked in a day when it =>12-hours.  For example, if a person clocks in for 6 hours, clocks out for a break, works another 6 hours and clocks out again, that would be 12 hours for the day.  Right now I am only capturing when they work 12 hours without a break.  I tried filtering the report when ADP_Labor[Final Hours]>=12, but that did not work (it pulled everything).  I thought the following Measure would work, but maybe I am missing something.  Please advise.

12+ Hours = CALCULATE(sum(ADP_Labor[Final Hours]),ADP_Labor[Final Hours]>=12)

[drinko]

This is all in one table.  In this example you can see the detail on the top that shows this Associate highlighted that worked 15.25 hours on 1/6/21.  They worked 12 hours and then 3.25 on the same day.  You see on 1/9/21, they worked a total of 22.5 hours, but all the clock-ins to clock-outs were less than 12 (like they worked three 7-hour sessions).   I want to capture those combined hours for the day rather than only sessions that were greater than 12, but my formula is not working.

[v-lionel-msft]

Hi @drinko ,

Is this what you want? If not, please provide a sample data and expected output.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[drinko]

yes, that is the expected output I want to capture with exception to the "11".  I don't want to capture any records where the hours for that day were less than 12.  Looking for the formula to only show the name, date, and # of hours for any sums greater than or equal to 12.  How do I write this?

[Portrek]

DEPENDS ON HOW YOUR DATA IS STRUCTURED, POST AN IMAGE WITH SAMPLES FROM YOUR BANK, WITHOUT POSSIBLE COMMITMENT DATA, SO WE CAN HELP YOU...