Constant line in bar and column chart

[pooofy]

Hi,

I am using a bar and line chart, but require to write a measure to show a constant line (horizontal), which is based on another measure.

This is my current measure:

Average No. of Claims for 3 years = 
var maxyear = MAXX(Table, Table[Claim Payment Date].[Year])
var minyear = maxyear - 2
var result = Calculate(average(Table[No. of Claims per Year]),
filter(ALL(Table), Table[Claim Payment Date]
.[Year] <=maxyear && Table[Claim Payment Date].[Year]>=minyear))
return result

How do i convert my measure to show a constant line instead? 

Thank you!

[pooofy]

Sorry, I need to use the column and line chart. Thank you!

[Uzi2019]

Hi @pooofy 
You can add constant line in Line chart from here.

You can add your measure value under this category

I hope I answered your question. please give kudos and accpet as a solution!
Thanks!