Calculated Measure based on 2 other measures to find delta

Questions & Answers
1

Greetings,

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.
Thanks!

Drew

2022-07-28_18h01_47
2022-07-28_18h01_47884×482 57.5 KB

2

Hi @drewwiseman

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

CASE WHEN
  [Measures].[Issue Story Points] > 0
  AND
  [Measures].[Original story points created] > 0
THEN
  [Measures].[Issue Story Points]
  -
  [Measures].[Original story points created]
END

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