Dynamic overdue status based on date selection not working properly

[PetrovBI]

Hi,

I have account receivables consisting of invoices, their close/pay date (can be blank), due date (not blank), and a transaction date among other fields. 

I have already calculated a static overdue/not overdue status field based on today's date. However, I need to create a dynamic overdue/not overdue status measure because I want to look at the status of an invoice based on the last date of the date period that I select/filter on.

I am using a date period slicer (between). 

I did manage to fetch the last date of the period with

"Period End-Date = CALCULATE(MAX(Calendar[Date]), ALLSELECTED(Calendar[Date]))"

Then I tried creating the dynamic status field as following: 

Dynamic Status = IF(DATEDIFF([Period End-Date], MAX(AccountReceivables[DueDate]), DAY) >= 0, "Not Overdue", "Overdue")

It worked for the majority of rows, but some rows receive the wrong status, "Not Overdue" even if the due date is behind the period end-date, for instance due date - 30/12/2022 vs period end-date - 31/12/2022. 

What could I be doing wrong? Sadly, I cannot share the data.

Thank you in advance! 

Best regards