D365 F&O Data entity range

Hi all,

I have created a data entity which has multiple data sources my requirement is - to remove all records having a specific field value. I have added a range with field name and value which is not required eg !1, !2 however the data source on which this record is present needs to have outer join. Whenever my records having the specified values the field is having null but records are showing in my entity view can anyone suggest me an alternative to achieve this ie completely remove records from entity having the field values 1 or 2. Thanks in advance!