Summarize Total By Weighted Average

Question

How does one summarize by weighted average?&nbsp; This seems like it should be a straightforward thing.&nbsp; When I click on the calculated column I am working with my options are:Weighted average isn't there.&nbsp; Perhaps there is a way to change the word "Total"&nbsp; at the foot of the table to "Weighted Average"&nbsp;and create a calc. if this isn't in the work at MS?&nbsp;&nbsp; I am trying to avoid having to build a completely&nbsp;independent table and overlay it on the existing table.&nbsp; &nbsp;If there is a work around while weighted average is added to the summarize options within desktop, then please read on.&nbsp;&nbsp;The values I am working with are:&nbsp;Measure = Numerator/Denominator&nbsp;IDPersonNumeratorDenominatorMeasureMonth1234Person A17210.80952417-Sep5678Person B16180.88888917-Sep91011Person C73770.94805217-Sep121314Person D88117-Sep&nbsp;&nbsp;The Dax is:&nbsp;Sep-17 = DIVIDE(
        calculate(
                sum('% New Sch 30'[New Within 30 Qty]),'% New Sch 30'[Month] = "Sep-17"),
        calculate(
                sum('% New Sch 30'[Arrived Completed Qty]),'% New Sch 30'[Month] = "Sep-17"))Any help here is greatly appreciated!&nbsp;Thanks in advance,&nbsp;Mark

v-juanli-msft · Accepted Answer

Hi&nbsp;S184019
To get&nbsp;weighted average as you expected, try this formula
measure2&nbsp;=DIVIDE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM&nbsp;(&nbsp;Sheet11[Numerator]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;ALL&nbsp;(&nbsp;Sheet11&nbsp;),&nbsp;[Month]&nbsp;=&nbsp;DATE&nbsp;(&nbsp;2018,&nbsp;9,&nbsp;17&nbsp;)&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM&nbsp;(&nbsp;Sheet11[Denominator]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;ALL&nbsp;(&nbsp;Sheet11&nbsp;),&nbsp;[Month]&nbsp;=&nbsp;DATE&nbsp;(&nbsp;2018,&nbsp;9,&nbsp;17&nbsp;)&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;))

&nbsp;
&nbsp;
Best Regards
Maggie

Forum Discussion

Summarize Total By Weighted Average

2 Replies

Related content

Calculating Weighted Average

Weighted Average DAX

Weighted Average Measure

Summarize average monthly table

Weighted average by month

ID	Person	Numerator	Denominator	Measure	Month
1234	Person A	17	21	0.809524	17-Sep
5678	Person B	16	18	0.888889	17-Sep
91011	Person C	73	77	0.948052	17-Sep
121314	Person D	8	8	1	17-Sep