DAX equivalent of SQL

[Anonymous]

Hi 

I want to write optimised DAX equivalent of following SQL query 

SELECT MID,  SUM(Value1) FROM
(
SELECT mrd.SUID, mrd.MID, mrd.TAG, MAX(mrd.Value1) MeasValue1 FROM Table1 AS mrd
WHERE mrd.CustomerID=2
AND mrd.DateKey BETWEEN '20170101' AND '20171231'
GROUP BY mrd.SUID, mrd.MID, mrd.TAG 
order by mrd.SUID, mrd.MID, mrd.TAG
)
a
GROUP BY  MID

[v-jiascu-msft]

Hi @Anonymous,

Could you please share a dummy sample? The DAX formula depends on the data model, especially the relationship and the structure.

Best Regards,

Dale