Calculate Annual Flat Rate on Monthly Graph

PurpleWave22 — Mon, 17 Apr 2023 18:08:07 GMT

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

I have three tables:

Complaint Table: breakdown of product complaints
Date Table
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:

A flat average complaint rate for the year
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!

Re: Calculate Annual Flat Rate on Monthly Graph

Mahesh0016 — Tue, 18 Apr 2023 06:01:45 GMT

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.

Re: Calculate Annual Flat Rate on Monthly Graph

PurpleWave22 — Tue, 18 Apr 2023 19:39:06 GMT

That worked! Thanks so much for your help.

topic Calculate Annual Flat Rate on Monthly Graph in DAX Commands and Tips

Calculate Annual Flat Rate on Monthly Graph

Re: Calculate Annual Flat Rate on Monthly Graph

Re: Calculate Annual Flat Rate on Monthly Graph