How do I make sure a max formula is affected by my date filter?

[ThomasWeppler]

Hi Power Bi community
I have a table which contains the status of diffrent projects at diffrent times.
It look like this.

I want to find the last stateid based on the date and todoid.
So I use a Dax formular like this.
Luckly a higher id always means a later date so I can use this Dax code.

Status IGA =

var _maxid = MAX(Todostatehistory[id])

return

LOOKUPVALUE(Todostatehistory[stateid], Todostatehistory[id], _maxid)

When I place it in a table it will only look at the relevent todoid. 
However I also has a filter which filter on the highestdate based on the date., but it doesn't seem to affect my dax code.

So my question is what can I do to make sure my Dax is affected by my Date filter?

[Anonymous]

Hi @ThomasWeppler ,

Glad to hear that your problem has been solved. Could please mark your reply as a solution and then more people will benefit from it.

Best Regards,

Stephen Tao

[Greg_Deckler]

@ThomasWeppler If you are using your Dato column as your date filter then assuming this is a slicer or something in the Filter pane then this should already be filtering your rows in that table. Is that what you are doing or something else?

[ThomasWeppler · Accepted solution]

@Greg_Deckler 
Ok I found the problem.
I used a calender table so one slicer could affect multiple tables.

But the date colum in my table was thype = time date/ time while my calender table colum hads the type = date.

Thanks a lot for the help Greg, sometimes you just need the right question to start thinking in a new way.
A moderator can close this thread.