Calculated Measure based on 2 other measures to find delta


I am using 2 fields on the Initiative issue type:

  1. ‘Original Story Points’ to capture the original estimate
  2. ‘Story Points’ to capture a later, revised estimate
    I have built a report that lists the Initiatives in a table column A, with original story points in column B and story points in column C. I want to add a column D that calculates the ‘delta’ between B and C. It could be a positive or negative number. Also, in some cases, B or C or both will be blank, in which case I don’t want any value in D. I only want to show a value in D (for the delta) when both B and C are not empty.

I tried to use coalesce empty but that stripped a bunch of Initiatives off of the results, which is not what I want.

How can I do this? See my screenshot.


Hi @drewwiseman

You can achieve this by introducing a CASE statement in your formula:

  [Measures].[Issue Story Points] > 0
  [Measures].[Original story points created] > 0
  [Measures].[Issue Story Points]
  [Measures].[Original story points created]

Let me know if this fits your use case!
Best regards,
Nauris / eazyBI support