Convertir SQL en DAX

¿Puede ayudarme a convertir el siguiente SQL en una consulta DAX, será de gran ayuda!

```

WITH course_lesson_counts AS (
    SELECT 
        cl.course_id, 
        COUNT(cl.lesson_id) AS total_lessons
    FROM course_lessons cl
    JOIN lessons l ON cl.lesson_id = l.id
    WHERE cl.publish_map_id IS NOT NULL AND l.publish_map_id IS NOT NULL
    GROUP BY cl.course_id
),
halfway_users AS (
    SELECT 
        ucp.course_id, 
        ucp.user_id, 
        COUNT(clp.lesson_id) AS completed_lessons
    FROM user_course_progress ucp
    JOIN course_lesson_progress clp ON ucp.user_id = clp.user_id AND ucp.course_id IN (
        SELECT course_id FROM course_lesson_counts
    )
    WHERE clp.progress_status IN ('in_progress', 'completed')
    GROUP BY ucp.course_id, ucp.user_id
)
SELECT 
    c.id AS course_id,
    c.name AS course_name,
    COUNT(DISTINCT hu.user_id) AS halfway_user_count
FROM courses c
JOIN course_lesson_counts clc ON c.id = clc.course_id
LEFT JOIN halfway_users hu ON c.id = hu.course_id AND hu.completed_lessons >= (clc.total_lessons / 2)
WHERE c.publish_map_id IS NOT NULL 
AND c.paid_type = 'paid'
GROUP BY c.id, c.name;