Cumulative line graph - one measure totalling incorrectly

Question

Hello all,First time post so hopefully I am including everything I need to be clear.&nbsp;I am trying to show the number of 'created issues' against number of 'closed issues' along a date axis (beginning of a new week (Monday to Sunday)).&nbsp; I would like the cumulative measure to calculate all issues created between 1st August 2023 to 8th January 2024 and not only the relative timeframe of the visual (last 12 weeks) which i do want for the bars.&nbsp; The report page is filtered to exclude issues created pre 1st August 2003 and post 8th January 2024.Created Issues, Closed Issues and Created Issues (cumulative) are all coming through perfectly.&nbsp; The problem I am having is the Closed Issues (cumulative) line which is stepping up correctly but is totalling to the total amount of the created issues which is incorrect.&nbsp; In the attached example, the cumulative line should end up as 98 not 552.&nbsp;&nbsp;I have two inactive relationships between my date table and the created at and closed at dates in my data table.&nbsp;&nbsp;The measures I am using are as follows:# Created Issues by Date =CALCULATE(&nbsp; &nbsp; COUNTA('issues_issues'[created_at]),&nbsp; &nbsp; Filter('issues_issues',&nbsp; &nbsp; COUNTROWS(FILTER(VALUES('Date'),&nbsp; &nbsp; 'issues_issues'[created_at]= 'Date'[Date]))&gt;0))&nbsp;# Closed Issues by Date =CALCULATE(&nbsp; &nbsp; COUNTA('issues_issues'[created_at]),&nbsp; &nbsp; Filter('issues_issues',&nbsp; &nbsp; COUNTROWS(FILTER(VALUES('Date'),&nbsp; &nbsp; 'issues_issues'[closed_at]= 'Date'[Date]))&gt;0))&nbsp;# Created Issues by Start of Week (cumulative) =CALCULATE(&nbsp; &nbsp; [# Created Issues by Date],&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; ALL('Date'[Start of Week (Monday)]),&nbsp; &nbsp; &nbsp; &nbsp; ISONORAFTER('Date'[Start of Week (Monday)], MAX('Date'[Start of Week (Monday)]), DESC)&nbsp; &nbsp; ))&nbsp;# Closed Issues by Start of Week (cumulative) =CALCULATE(&nbsp; &nbsp; [# Closed Issues by Date],&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; ALL('Date'[Start of Week (Monday)]),&nbsp; &nbsp; &nbsp; &nbsp; ISONORAFTER('Date'[Start of Week (Monday)], MAX('Date'[Start of Week (Monday)]), DESC)&nbsp; &nbsp; ))&nbsp;I can't identify where I am going wrong.&nbsp; Any help would be much appreciated.&nbsp;Many thanks.&nbsp;&nbsp;

anonymous · Accepted Answer

Thank you - I have managed to resolve the issue.&nbsp; I hadn't excluded the blank closed items in the measure.

Forum Discussion

Cumulative line graph - one measure totalling incorrectly

2 Replies

Related content

Cumulative Total

Cumulative Total

SumX? - cumulative running total

Cumulative Total

Cumulative total