cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ubaddala Frequent Visitor
Frequent Visitor

SQL to DAX

I have the below query and I need to convert this to DAX. There is a DIM - Individual created in the SSAS tabular model.

 

select count(distinct i.indv_id) cnt

from ods.wfts_individual_d i

where i.trace_type = 'T'

and i.role_played in ('S', 'P')

and i.indv_id in (

    select indv_id

    from (select indv_id, role_played from ods.wfts_individual_d where trace_type = 'T' and role_played in ('S', 'P') ) x

    group by indv_id

    having count(indv_id) > 1

    )

-- 370,376

 

Thanks in advance,

Uday

1 REPLY 1
Community Support Team
Community Support Team

Re: SQL to DAX

Hi @ubaddala,

 

To get the solution more quickly, please share some data sample and your desired output so that we could help further on it.

 

In addition, you could have a reference of this article.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.