Weighted average total

Question

Hi All,&nbsp;I try to calculate weighted averege using such a measure. Results in rows are correct but the Total row is displaying only SUM(RC_TTOValue[TTOValue]). Do you know what is needed to be changed here? Thanks&nbsp;DIVIDE(&nbsp; &nbsp; &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RC_TTOValue,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RC_TTOValue[TTOValue]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; * SUMX(POS360_PL,CALCULATE(SUM(POS360_PL[Volume]),POS360_PL[PLItemId]="Volume"))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE(SUM(POS360_PL[Volume]),POS360_PL[PLItemId]="Volume",ALLSELECTED(POS360_PL),ALLSELECTED(RC_TTOValue))&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; )&nbsp;

greg_deckler · Answer

Anonymous&nbsp;See if this helps:&nbsp;https://community.powerbi.com/t5/Quick-Measures-Gallery/Better-Weighted-Average-per-Category/m-p/2805460#M895
And the video:

Forum Discussion

Weighted average total

1 Reply

Related content

Calculating Weighted Average

Weighted Average DAX

Weighted Average Measure

Weighted Average Total Measure

Weighted average incorrect total