Average Of A Calculated Measure

Question

I would like to create a bar graph in Power BI that shows the monthly trend of a particular number on selected months, along with a straight line representing the average of all the sums of selected months. Could you please assist me with the formula for calculating the average measure field?

analyticpulse · Answer

hello&nbsp;_Moosa_&nbsp;try below solutioncreate this measre for sumMonthlySum = SUM('YourTable'[Number])&nbsp;below measure for averageAverageMonthlySum =AVERAGEX(VALUES('YourDate'[Month]),[MonthlySum])&nbsp;&nbsp;&nbsp;Learn Power BI free:https://analyticpulse.blogspot.comPower BI : getting started Dax functions powerbi Visualisation&nbsp;&nbsp;

_moosa_ · Answer

Thanks for your reply but this dosent help i need a straight line foa average this solution calculates moving average on monthly basis.

lbendlin · Answer

Use AVERAGEX over ALLSELECTED.

_moosa_ · Answer

Still not working

Forum Discussion

Average Of A Calculated Measure

4 Replies

Related content

DAX Measure for Ranking the valid rows and calculating the average rating

DAX Calculated Measure

calculate average of calculated measure

Calculating Weighted Average

Calculating average 12 month average