Convert SQL Calculations into DAX - MMC, Average, Discount, Average Discount

min-E 

You need to create four measures as follows:

MMC = SUMX(TableName, TableName[Qty] * TableName[Price])

AvgMMC = DIVIDE([MMC], SUM(TableName[Qty])) + 0

MMCDisc = SUMX(TableName, TableName[Qty] * ROUND((TableName[Price] * TableName[C_adj]) * TableName[G_adj], 2))

AvgDisc = IF(MMC = 0, 0, DIVIDE(SUMX(TableName, ROUND((TableName[Price] * TableName[C_adj]) * TableName[G_adj], 2)), SUM(TableName[Qty])))

I don't recommend the approach of translating SQL or any other programming/querying language to DAX, but you can proceed like the following :

MMC = SUMX('mytable', [qty] * [price])
AvgMMC = DIVIDE([MMC], SUM('mytable'[qty]))
MMDisc = SUMX('mytable', [qty] * ROUND([price] * [c_adj] * [g_adj], 2))
AvgDisc = DIVIDE(SUMX('mytable', [qty] * ROUND([price] * [c_adj] * [g_adj], 2)), SUM('mytable'[qty]))
AvgDisc Direct = AVERAGEX('mytable', ROUND([price] * [c_adj] * [g_adj], 2))

Both of these have worked and helped me understand much better how this works. Thank you!!!