Help Please Incorrect DAX code

CalculatedPay = IF
                (
                    [Calculation Date] < [Applicable Payroll Date],
                    --then--
                    0, 
                    --else--
                    VAR payrollId = [Payroll Day ID]
                    VAR empID = [Employee_ID]
                    RETURN CALCULATE(SUM('Ordinary Hours'[AUD Total Daily Earnings]),FILTER('Ordinary Hours',[Payroll Day ID]=payrollId && [Employee_ID]=empID))    
                )

 I then tried to do a group by sum  as below however, it repeats the column values and when I display in the viz, the aggregate sum of that column is incorrect

Calculated Pay (N) = 
CALCULATE (
 SUM ( 'Ordinary Hours'[AUD Total Daily Earnings] ),
 ALLEXCEPT (
 'Ordinary Hours',
 'Ordinary Hours'[Employee Name],
 'Ordinary Hours'[Applicable Payroll Date].[Date]
 )
)

The excel formula that works is:

=IF(AND(E2>=D2,F2<>F3),F2,0)

Of course excel can refer to cells in above and below rows but this is the DAX part (I am new to this) I am trying to figure out.

Greg_Deckler suggested me to go down the index path here however, I am to new with Power BI to do it correctly.
Thank you so much!
Please help me with the correct code for the CalculatedPay or Calculated Pay (N) column.

Many Many Thanks!