Forum Discussion

monicajsv's avatar
monicajsv
Frequent Visitor
3 years ago
Solved

Cumulative Progress

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's avatar
    FreemanZ
    3 years ago

    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()))

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    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()))