I am using the following measure that basically rolls up 2 "week ending" periods for each employee, it adds together the "hours" in "week ending" to calculate overtime (measure subtracts 80 from total sum of hours for those two weeks to calculate overtime). The problem I'm having is that when I add the measure to a visual table I'm creating, it displays the total by including both negative and positive numbers. I only want the positive numbers since those are the overtime hours.
So, basically, I'm not sure how to filter out negative numbers so that the total is only made up of positive numbers (overtime).
var _a = RANKX(ALLEXCEPT('Table','Table'[Employee]),[Week Ending],MAX('Table'[Week Ending]),ASC,Dense)
var _b = MAXX(FILTER(ALLEXCEPT('Table','Table'[Employee]),[Week Ending]<MAX('Table'[Week Ending])),[Week Ending])
var _c = CALCULATE(SUM('Table'[Hours]),FILTER(ALL('Table'),[Employee]=MAX('Table'[Employee])&&[Week Ending]<=MAX('Table'[Week Ending])&&[Week Ending]>=_b))-80