Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
and it works perfectly!
But when I want to calculate the accumulated number of closed incidents using this measure:
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!
Solved! Go to 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()))
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()))