Setting User Specific Filter

[SarahMcCann]

Hi, 

I am trying to set my filter so that each user has their own filter. I have the filter in the User table and it will filter the Budget table to show specific budget for the job selected. 

The filter will work when it is set like: 

ANY(Users[Filter]) = [Job]

However this is not user specific the same filter is used for everyone. 

When I change it to the below it is not working but how else do I have it user specific. 

ANY(SELECT(Users[Filter], USEREMAIL()=[User Email]))=[Job]

Any help would be great. Thanks