Was the Story Points resolved measure recently changed to return empty instead of 0?

Questions & Answers
1

I have many reports that use the Story Points resolved measure and now they all appear broken. Some debugging lead me to find that the measure is returning empty, instead of 0, which is causing choppy-looking data in a timeline report using area - stacked - percentage. The same report previously looked smooth, so I am wondering if the measure was changed in 7.2.0 or another recent release.

Previous display of the chart:
image
Current display of the chart:
image

2

When I change the measure from Story Points resolved to

CoalesceEmpty([Measures].[Story Points resolved], 0)

the chart looks like this:
image

3

Hi @cchase,

The actual measure was not changed.

A minor background update was done for the display of the percentage stacked area timeline chart to remove the automatically applied “empty as zero”.

The latest option is displaying data exactly as it is visible in numbers, leading to more transparency for the customer.

You can regain the previous approach using the construction.

CoalesceEmpty([Measures].[<measure name>], 0)

Still, this might lead to a slide to zero for future periods, which can then be fixed using the following approach.

CASE WHEN
 DateCompare(
 [Time].CurrentHierarchyMember.StartDate,
 [Time].CurrentHierarchy.[Day].CurrentDateMember.StartDate)<1
 THEN
 CoalesceEmpty(
   [Measures].[<your measure here>],
   0)
 END

This gives you more control over where the chart ends and if it should slide to zero or be cut sharply.

Regards,
Oskars / support@eazyBI.com

1 Like