need help to connvert sql query to dax

Hi,

      I have a sql query i need to implemet in dax.

select distinct id, name
from table1
where product= 'abc' and not exists (
select manufacturer, manu_name
from table2
where ltrim(rtrim(category)) <> 'AD' and column1= column1 and name= manu_name)

Thanks in advance