Stack area chart with cumulative

[hugoss]

Hi there,

Could any one help me understand where my mistake is and how to fix it? I'm trying to depicture how our team has been dealing with issues over time (number of issues created vs number of issues resolved). In order to do that, I'm using a stack area graph setted with the following fields:
X axis = [Data Criação Ref] it's the date when the issue was created
Legend = [Fechada] it's a boolean field indicating if the issue is closed (true) or is open (false)
Values = [Qtd Acumulada por data] this field calculates the cumulative number of issues (its formula is presented on the image bellow).

Stacked Area Graph with cumulative count


By checking the image above, you might see the problem. The "True" values is been calculated cumulative, but False  values are not. False values has been calculated only for some specific days and not cumulative. Could anyone help me out here?

[v-xuding-msft · Accepted solution]

Hi @hugoss ,

By my test, you need to modify the measure. The following is my sample you reference.

I have two tables. The table of Date is a calendar table. And there is a many-to-one relationship between them.

Date = CALENDARAUTO()

Measure = var a = CALCULATE(SUM(Table1[column]),FILTER(ALL('Date'),'Date'[Date]<=MAX('Date'[Date])))

var b = CALCULATETABLE(VALUES('Table1'[Date]),ALLSELECTED(Table1))

return

IF(MAX('Date'[Date]) in b,a,BLANK())

Note : You have to add the column of Date from the calendar table to Matrix, not the Date from others.

Best Regards,

Xue Ding

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

[hugoss]

thanks a lot for your help, @v-xuding-msft. It worked perfectly