Filter Applied to Table with Datediff column not filtering out values correctly

[sjrrkb123]

So I have a column for years of experience using DATEDIFF(). The values that it returns are correct; however, when I apply a filter to the table, all values are filtered except the "years of experience column."

Here is my code for the column:  

 var end_dt = 'Pro - Dim Professional'[EmploymentEndDate].[Date]
 var recent_hire_dt = 'Pro - Dim Professional'[Start Date].[Date]

RETURN
IF(ISBLANK(end_dt), DATEDIFF(recent_hire_dt, NOW(), YEAR),
    IF(recent_hire_dt > end_dt, DATEDIFF(recent_hire_dt, NOW(), YEAR),
         DATEDIFF(recent_hire_dt, end_dt, YEAR)))

Here is a screenshot of my problem after the filter is applied. 

Is this perhaps because not all fields in the table (like a person's name) is a column and a calculated value?

[az38 · Accepted solution]

Hi @sjrrkb123 

set inactive parameter "Show items with no data" in fields settings Visualization pane

and of courcse, check your data, it looks like you have rows with non-empty start date but empty "Util", "DL Hours" or other columns

[sjrrkb123]

Data was the issue, I forgot I had done some fiddling with the start date column prior to this and it was including values it shouldnt.