How to create an average line measure in PowerBi

[Anonymous]

Hi,

I want to use a measure to create an average line for this chart (I don't just want to use the visual average line you can get in Analytics bit of PowerBi).

My chart looks like this:

I started by trying just to create a simple average 

Average 1 = AVERAGE('ROI Sites'[Volume (MWh)])

However, you can see from the table it creates an average of individual volumes in each day (not the average of the day in total)

I then tried to create an average which gives me the average of each day.

Average 2 = CALCULATE(AVERAGEX('Dates',[Total Volume]),ALLSELECTED('Dates'))

This got me a the correct total average, but for each day the average just represents the volume for that day. How can I alter the measure from here so that the average is 14.32 for each day?

Thanks,

H

[amitchandak]

@Anonymous , Try like

calculate(AVERAGE('ROI Sites'[Volume (MWh)]), allselected())

or use the measure AVERAGE('ROI Sites'[Volume (MWh)]) in analytics Tab - constant line using fx option

[Anonymous]

@amitchandak thanks for your reply.

I've tried your first suggestion (which I called Average 3) but that puts everything at 0.15 which is far too low?

I don't quite understand what you are saying for the second option either - if you could clarify that would be great.

Many thanks,

H