SQL to DAX

[Anonymous]

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

[v-piga-msft]

Hi @Anonymous,

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