Equivalent logic from SQL to DAX

[Anonymous]

How to write Dax expression in Power BI from the given SQL:

select  
        --Job_ID,
       -- Run_ID,
        CREATED_DATE_TIME ,
        Data_domain ,
        Field_Name  ,
        rule_name   ,
        rule_description,
        check_name,
        check_description,
        check_value,
        severity,
        dataset_count,
        count(1) as ValidationFails
from    DATA_QUALITY.RESULTS_VIEW
WHERE   1=1
AND     Data_domain = 'ny_medclaim_details'
and     to_date(created_date_time) = '2022-10-20'
AND     CHECK_NAME = 'lengthCheck'
GROUP BY
    --    Job_Id,
    --    Run_ID,
        CREATED_DATE_TIME ,
        Data_domain ,
        Field_Name  ,
        rule_name   ,
        rule_description,
        check_name,
        check_description,
        check_value,
        severity ,
        dataset_count
ORDER BY 1

[AnkitKukreja]

Hi! @Anonymous 

It is possible to achieve the solution with DAX but it cannot be equivalent to an SQL query. Please share the expected solution that you want to achieve with the data.