Power BI - Measure to Multiply, Sum, Divide and Average

[Jaelah]

Hi peeps! decided to break my problem down further. So in the table; i have Amt, rate, Standard %. these are to be multiplied and summed up daily.

it then needs to be divided by the sum of the rate.

and finally, for the whole month of jan-2018 for eg, it will take the average of those.

the attachment will explain as well.

[Sadath31]

HI

Calculated Column (Column Name is Total) =[Amt]*[rate]*[Standard %]

Total Rate:=SUM(Table1[Total])/sum(Table1[rate])
Average:=AVERAGEX(values(Table1[Date]),[Total Rate])

In Pivot report Date in Rows and Average in Value
Group the Date by Month

[Jaelah]

awesome! i tried to squeeze all into one but got a different result. would be great if you can help explain.
ModifiedAverage = AVERAGEX(VALUES(Table3[Date]),SUMX(Table3,Table3[Amt]*Table3[rate]*Table3[Standard %])/SUM(Table3[rate]))

but works great if i squeeze into two, omitting the calculated column.
TotalRate = SUMX(Table3,Table3[Amt]*Table3[rate]*Table3[Standard %])/SUM(Table3[rate])
Average = AVERAGEX(VALUES(Table3[Date]),[TotalRate])