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 (
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
Thanks in advance,
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.