Cumulative Progress

[monicajsv]

Hello,

I have a table with open issues in Jira and all issues have a creation date ("Created" column), but only some have a resolution date ("Resolved" column). I am calculating the cumulative number of open issues using the following measure:

Cumulative Issuess = CALCULATE(COUNTROWS('jira-model Issue'),filter(ALLSELECTED('jira-model Issue'),'jira-model Issue'[Created]<=MAX('jira-model Issue'[Created])))

and it works perfectly!

But when I want to calculate the accumulated number of closed incidents using this measure:

Cumulative Issues Resolved = CALCULATE(COUNTROWS('jira-model Issue'),filter(ALLSELECTED('jira-model Issue'),'jira-model Issue'[Resolved]<=MAX('jira-model Issue'[Resolved])))

it also counts the ones that have the resolution date field empty, How do I not count those that do not have a date because they are still open incidents?

Thanks!

[FreemanZ · Accepted solution]

hi @monicajsv 

because a blank value is also <MAX(...)

try like:

Cumulative Issues Resolved = CALCULATE(COUNTROWS('jira-model Issue'),filter(ALLSELECTED('jira-model Issue'),'jira-model Issue'[Resolved]<=MAX('jira-model Issue'[Resolved])&&'jira-model Issue'[Resolved]<>BLANK()))