How do i show a month data and a year data in the same graph?

[jeo]

Hi all,

I want to put a data for monthly and a data for yearly i the same line grah. The yearly data will be divided by the number of months which is wrong.
This is what the graph is currently showing.This is what i want it to show

Regards,
Jeo

[amitchandak]

@jeo , Ideally you should use removefilter of all to make monthly data yearly

example

calculate([Meausre], removefilters(date[Month])

or

example

calculate(Averagex(Values(Date[Month Year]), [Meausre]) , removefilters(date[Month])

You can put logic to show value only in June

If( Month(Max(Date[Date]) ) =6, calculate(Averagex(Values(Date[Month Year]), [Meausre]) , removefilters(date[Month]), blank() )