SQL to DAX

Hi everyone! How do you convert this querry into DAX?  I want to standardize queuries and was hoping it's possible to have this one as a measure/table(s).   WITH cte_elevation AS (      select we...