Help with error in calculating Cumulative

[Anonymous]

Hi all,

I need help with solving an error with calculating a cumulative. I am calculating a cumulative of backlog issues by Date.

My current measures are

• Open bugs = Distinctcount('GetIssues'[Id])  Note: My active relationship with the date key table is 1:n Datekey[Date]:GetIssues[CreatedDate]
•  Closed Bugs = CALCULATE(DISTINCTCOUNT(GetIssues[id]),USERELATIONSHIP(GetIssues[ClosedDate],DateKey[Date]))

• Backlog issues= CALCULATE([open bugs]- [closed bugs],FILTER(ALL('Datekey'[Date]),AND('Datekey'[Date] <= MAX ('Datekey'[Date]), Datekey[Date] >= DATE(2015,01,01)))) 

        Datekey[Date] >= DATE(2015,01,01)- I have added this above as i need to count the issues only from this date onwards 

Now the problem am facing is that, when there is no issues opened on a day the backlog line breaks but the consequent cumulative is calculated correctly .i.e.

In the below graph on 10th the backlog is 274 , 12th 1issue was closed hence on 12th backlog is 274-1=273

On 13th 3 were open and 11 closed i.e. 273+3 -11 = 265. This value is correct but i need the line to be continous

Thanks in advance for your help.

Regards 

[v-yulgu-msft]

Hi @Anonymous,

In my test, the cumulative measure added to chart generated a continuous line without any break. Please provide some sample data in table 'GetIssues' so that I can try to reproduce.

Regards,

Yuliana Gu