Calculate Annual Flat Rate on Monthly Graph

[PurpleWave22]

I'm having some difficulty in calculating a flat annual rate on a monthly graph.

I have three tables:

1. Complaint Table: breakdown of product complaints
2. Date Table
3. Case Table: breakdown of number of product cases by date

Complaint Table is related to Date Table through a creation date field while the Case Table is related to the Date Table through case date field.

I have a combo line and stacked column chart where the bars are the number of complaints, the line is the complaint rate, and the x-axis is date displayed on a year-month level:

The goal is to add two flat lines to the graph: 

1. A flat average complaint rate for the year
2. 3x the standard deviation of the complaint rate for the year

I'm just not sure how to calculate on an annual basis when the graph is displayed on a monthly basis.

For reference:

Complaints =
CALCULATE (
    DISTINCTCOUNT ( 'Complaint Table'[Complaint ID] ),
    'Complaint Table'[Is this a complaint?] = "Yes"
) + 0

FT Complaint Rate = 'Complaint Table'[Complaints] / SUM('Case Table'[Total Cases])

Any help would be appreciated!

[Mahesh0016 · Accepted solution]

@PurpleWave22 Please try this measure 

Complaints =

CALCULATE (

    DISTINCTCOUNT ( 'Complaint Table'[Complaint ID] ),

    'Complaint Table'[Is this a complaint?] = "Yes",

    ALLSELECTED('Complaint Table'[Year])

) + 0

@PurpleWave22 i hope this help you.

[PurpleWave22]

That worked! Thanks so much for your help.