Dax formula Help

[Anonymous]

Can any one convert sql query into dax please,

SELECT SUM(
CASE
WHEN vis.CODTYPSUR = par.valpar and vis.CODSTA= 5 THEN
1
ELSE
0
END
) ND,
vis.CODD

FROM dbo.TA vis
INNER JOIN (
SELECT CODD
,VALPAR
FROM dbo.T0
WHERE codpar = 'DE'
) par ON (vis.CODD = par.CODD)

WHERE vis.flgann = 0 and vis.CODSTA in (5,6)

GROUP BY vis.CODD

Thanks in advance

[TeigeGao]

Hi @Anonymous ,

Could you please share some sample data to us for analysis? We need to know the schema of tables.

Best Regards,

Teige