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 numbe...
  • 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()))

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