Forum Discussion

phanisri19's avatar
phanisri19
Regular Visitor
4 years ago

convert sql query to dax

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

3 Replies

  • BeaBF's avatar
    BeaBF
    Super User
    4 years ago

    Can you provide any details?

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

     

    B.