Creating a Average line in line chart which averages days of all teams for every month

[xlitol]

Hi - this is a trend line chart of days (y-axis sum of days cnt) of teams (legend TEAM) every month (x-Axis start_date_chop_mmyy). I need a line which averages the team count of teams every month. The default average line is a horizontal straight line which does not fit my requirement. I have one table - Main which is the data source. To the right are some filters applied to this chart (namely - absence_type, Active_status, start_date_chop_, team).

 
I guess DAX is required to write a measure for this. May I know how to do it? Not creating new table is preferred.

[Anonymous]

Hi  @xlitol ,

You can use the following measure:

Measure =
AVERAGEX(
    FILTER(ALL('Table'),
    YEAR('Table'[Start_Date_Chop_MMYY])=YEAR(MAX('Table'[Start_Date_Chop_MMYY]))&&
    MONTH('Table'[Start_Date_Chop_MMYY])=MONTH(MAX('Table'[Start_Date_Chop_MMYY]))),[Days Cnt])

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[xlitol]

any help is appreciated to get me started