Forum Discussion

connork's avatar
connork
Frequent Visitor
7 years ago

Annual Total not Calculating

I have the following measure to calculate overtime hours as the difference between actual hours worked [Hours] and 'regular' hours [OT Base2]:   OT Hoursv2 = IF(CALCULATE([Hours], all(refDate...
Need Help
connork's avatar
connork
Frequent Visitor
7 years ago

Hi v-yulgu-msft

Ok - here's the data, the measures and then a videw of the matrix with related columns:

DATA

dataTime

 

refDatesDAY

refEmployee

MEASURES

 

OT Hoursv2 = 
IF(CALCULATE([Hours],  all(refDatesDAY[Date])) - calculate([OT Base2], all(refDatesDAY[Date]))<0,0,
    CALCULATE([Hours],  all(refDatesDAY[Date])) - calculate([OT Base2], all(refDatesDAY[Date]))
)
OT Base2 = calculate(sum(refDatesDAY[OTBaseHours]),
        filter(refDatesDAY,
            refDatesDAY[Date]<=[MeasTerm]
            &&refDatesDAY[Date]>=[MeasHire]))
Hours = sum(dataTime[EMP_HOURS])

 

 

MeasHire = maX(refEmployee[Hire])
MeasTerm = max(refEmployee[Term])

 

 

REPORT VIEW