I have both FAW Admin role and Line Manager role, by removing the latter I solved the issue :)
@Stefano_Mazzocca - Please check the query generated for the filter using developer tools. Also verify running the same query directly on ADW and validate once. Hope this should give us some idea understand the cause of the behavior. Thanks!