How would the Dax logic need be written to replicate the same result as the built-in average line

[PBIViz_2024]

Hi,

I have line chart with Daily actual value for last 30day and I have used a average line as below to show the average of actual value which is a constant line for the period.It looks like below(red dashed line)pbix 

But the problem was when I used built in average line,it doesn't show in tooltip.But my user wants to see both average and actual values in the tooltip for each day.Since this can not be done with this built-in average line.I tried to create a measure and include it as a another line in the chart.But I failed to get a correct dax measure to deliver the same result as average value in the above line.My measure is always fluctuating with the date value.can some one help me on this. I am attaching this sample pbix for more info.

Can someone help me on this.

Regards,

[amitchandak · Accepted solution]

@PBIViz_2024 , If you have Avg measure , you can have measure like below and use that using FX option in constant line

Avg = calculate([Measure], removefilters(DateTable))

Avg = calculate([Measure], allselected())

or Avg of Month or day on a Sum measure

Avg Month = calculate(Averagex(Vales(Date[Month Year]), [Measure]) , allselected())

Avg Day= calculate(Averagex(Vales(Date[Date]), [Measure]) , allselected())

[PBIViz_2024]

Thanks a lot.It worked.