Table with measure cannot be filtered by a slicer

[chulpanvl]

Hello everyone!

I want to visualize the data from a task tracker.

I have a table with task titles, empluees to whom they were assigned, due dates and dates of completion. See a pbix file here. 

I want to show in the target table visual only not finished tasks (completion date is Blank and due date is Blank) and I want to show which of them are overdue at a given date (the last date in a Date slicer, in this case 12/04/2023). For that I created a measure

is_overdue = 

var maxdate = LASTDATE('Calendar'[Date])

return IF(MAX('IT-DF'[due date]) < maxdate, "Yes", "No")

However, when I try to filter the visual by the employee's name, the target is not filtered how I would expect it to be.

What I get and what I expect to get

Any advice how I could achieve my goal pls🙏

[johnt75]

In the table visuals use 'people'[assigned] rather than 'IT-DF'[name]

[chulpanvl]

This indeed works for my mock data but somehow doesn't for my real data. I included two identical table visuals with only one difference - the left one is without is_overdue measure, the right one - with the measure. For some reason the second visual assigns all lists of tasks to a person selected by slicer.

[johnt75 · Accepted solution]

I think its because the measure always returns a valid, non-blank, result. Try changing it to

is_overdue =
IF (
    SELECTEDVALUE ( 'people'[assigned] ) = SELECTEDVALUE ( 'IT-DF'[name] ),
    VAR maxdate =
        LASTDATE ( 'Calendar'[Date] )
    RETURN
        IF ( MAX ( 'IT-DF'[due date] ) < maxdate, "Yes", "No" )
)

[chulpanvl]

@johnt75 thank you for your help!!!