Paid and Unpaid overtime calculation

[mo1988]

I am trying to calculate weekly overtime of total duration

I have 2 types of overtimes: Paid & Unpaid.

Unpaid overtime: Weekly sum of total duration between 37.5 & 44 hours

Paid overtime: Weekly sum of total duration > 44 hours.

The formula for unpaid overtime I am using is the following:

Overtime = IF([TotalHours] > 37.5, IF(([TotalHours]-37.5)>6.5, 6.5, ([TotalHours]-37.5)), 0)

While using the Overtime DAX Formula, it does calculate properly on the row level but when it comes to Matrix Total, its always showing 6.5

Any way to fix this please?

Thanks

[Anonymous]

Hi @mo1988 

Can you provide the  outcome of the matrix visual or other sample data, Is the "[TotalHours]" a measure? What function did you wirte.  

Best Regards!

Yolo Zhu

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