DAX weighted average help for Power pivot

Question

&nbsp;&nbsp;Rm GroupValues&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Beans&nbsp;nuts&nbsp;Flour&nbsp;Date (Month)DocumentSum of Outstanding QtyWeight2Sum of Outstanding QtyWeight2Sum of Outstanding QtyWeight2AprSG10000001.068.350100000030000007000001700000&nbsp;PN683501.068.350100000030000007000001700000&nbsp;Dxb&nbsp;&nbsp;100000030000003000001700000Apr Total&nbsp;1068350&nbsp;3000000&nbsp;1700000&nbsp;MaySG10000002.000.000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PN10000002.000.000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dxb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;May Total&nbsp;2000000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;JunSG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Jun Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;JulSG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Jul Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OctSG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Oct Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NovSG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Nov Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DecSG&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Dec Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Grand Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I need help in creating a Dax formula for this pivot. I want the total outstanding qty for every month and group( Beans, nuts etc. to appear in the document rows ( just the yellow numbers.) How can I compute a DAX formula for that? Would really love to hear some suggestions as I have been struggling with this for days!

anonymous · Accepted Answer

Hi&nbsp;Tinkelbell&nbsp;,
&nbsp;
I think your table should look like as below.

You can try code as below to create a measure.
Weight2 = 
CALCULATE(SUM('Table'[Outstanding Qty]),ALLEXCEPT('Table','Table'[Date(Month)],'Table'[Rm Group]))
Result is as below.

&nbsp;
Best Regards,Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

DAX weighted average help for Power pivot

2 Replies

Related content

Calculating Weighted Average

Weighted Average DAX

Weighted Average Measure

weighted average in POWER QUERY

Weighted average by month

		Rm Group	Values
		Beans		nuts		Flour
Date (Month)	Document	Sum of Outstanding Qty	Weight2	Sum of Outstanding Qty	Weight2	Sum of Outstanding Qty	Weight2
Apr	SG	1000000	1.068.350	1000000	3000000	700000	1700000
	PN	68350	1.068.350	1000000	3000000	700000	1700000
	Dxb			1000000	3000000	300000	1700000
Apr Total		1068350		3000000		1700000
May	SG	1000000	2.000.000
	PN	1000000	2.000.000
	Dxb
May Total		2000000
Jun	SG
	PN
Jun Total
Jul	SG
	PN
Jul Total
Oct	SG
	PN
Oct Total
Nov	SG
	PN
Nov Total
Dec	SG
	PN
Dec Total
Grand Total