Distributing values between start and end date

Thank you for the insight here (on old query, with file example).

I have used the measure;

Measure_Paid = CALCULATE(SUMX(SUMMARIZE(filter(CROSSJOIN(PaidData,DatePAY),DatePAY[Date] >= PaidData[From] && DatePAY[Date] <= PaidData[To]),PaidData[ID],DatePAY[Date],PaidData[Amount],PaidData[From],PaidData[To]),DIVIDE(PaidData[Amount],DATEDIFF(PaidData[From],PaidData[To],DAY)+1)))

but am experiencing a problem when there is a credit and replacement payment. So in 2024 within the PaidData I have 3 transactions:

01/01/2024-31/12/2024 £1000
01/01/2024-31/12/2024 £-1000
01/01/2024-31/12/2024 £1000

The above seems to be ignoring one of the positives. It continues to show a net return of £0 paid for 2024.  X-axis graph

Tried to adapt measure but can't quite reach a valid execution. Have checked existing totals (new visualizations table) and using Sum in the build visual column dropdown it shows £1000 for the period, flick to Don't summarize it returns the £1000 and £-1000 as 2 entries, giving me £0 overall, but not the third line and final £1000.

Any tips gratefully received. At present this representation throws out £1000 as potentially outstanding with the SUMX(SUMMARIZE --what options would be available to tailor it for inclusion?  {Sorry - newbie here}