convert sql query to dax

[phanisri19]

Hi Experts, 
I have sql query which needs to be converted to dax
select count(id) as total from master
where id in
(select distinct pid from master
where type = 'yes')
and type = 'neutral'.

Thanks,
Phanisri

[BeaBF]

Okay, but can you post an example of a table you run that query on? @phanisri19 

B.

[BeaBF]

Can you provide any details?

Eg:
- do you need a calculated column, a measure, a table ...?
- table example
- result you expect

B.

[phanisri19]

@BeaBF , I need either as a measure or column for the above query