DATEDIFF measure not working (display blank) when difference is greater than ~450 days?

[alya1]

Hi All, 

I have a measure like below that is trying to dynamically find days since separation for customer IDs:

Days Seperated = 
VAR CurrentSeparationDate = SELECTEDVALUE('table1'[Sep Date])
VAR CurrentAdditionalSepDate = SELECTEDVALUE('table1'[Additional Sep Date])
RETURN
IF(
    NOT ISBLANK(CurrentSeparationDate),
    DATEDIFF(CurrentSeparationDate, [Date_selected], DAY),
    DATEDIFF(CurrentAdditionalSepDate, [Date_selected], DAY))

Sep Date and Additional Sep Date are columns and [Date-selected] is a measure based on a date slicer users can change. 

When I display the measure on a table visual it seems to work fine for some customers but the largest date diff listed is ~450 days. I know for a fact there are customers who separated longer than that (we have more than 20 years of data), but the table visual displays blank for them. 
Does anyone have idea why this is? 
I need to filter the page by Days Separated to be <= 365 or blank in the end! Thank you.

 

[alya1 · Accepted solution]

Ah apologies everyone, I figured out the problem: it was a date filter on the page that filtered out the sep date through indirect relationship. rookie mistake 

[FreemanZ]

hi @alya1 ,

how was [Date-selected] defined?

[alya1]

Date_selected = 
CALCULATE(MAX('Calendar'[Date]),ALLSELECTED('Calendar'))

I confirmed that it changes accordingly when the date slicer is edited.