Take into consideration Empty Value

Questions & Answers
1

Hello! We have a case where the Sprint Story Points completed/resolved is empty and the Average Sprint Story Points completed measure (user defined) does not take into consideration this empty value.

The current formula is:
CASE WHEN NOT IsEmpty([Measures].[Sprint Story Points completed]) THEN
ConstantColumnValue(CatchException(
Avg(VisibleRowsSet(),
[Measures].[Cumulative Story Points resolved])
))
END

We have in the report 3 values for completed story points: empty, 27 and 15. The average shows 21 which is not correct and should be 14.
Can you help adding the correct code in the formula to also take into consideration the empty sprint?
I’ve tried multiple possibilities and every time the answer was still 21. The source issues are from Jira and they we’re imported correctly.

Thanks!!

2

Hi @Beatrice_Av
Welcome to the eazyBI Community, and thanks for posting your question!
I recommend not mixing “Sprint Story Points completed” and “Story Points resolved”; instead, I recommend using the same measures. Resolved story points will interact well with Active Sprints.

You might want to try the formula below and see if it returns the expected results for you:

CASE WHEN NOT IsEmpty([Measures].[Sprint Story Points completed]) 
THEN
[Measures].[Sprint Story Points completed]/
[Measures].[Sprint issues completed]
END

Best wishes,

Elita from support@eazybi.com