How to get value from the calculated measure using conditions

Questions & Answers
,
1

Hi everyone!

Could you please help me with the following:

I have 2 calculated measures:

  • Story Points Completion %
  • Metric Compeltion %

What I need to do is to create a new calculated measure which will show the following:

  • If the Target Metric (it’s a custom field used in Metric Completion % calculation) is NOT empty then return “Metric Compeltion %”
  • ELSE return “Story Points Completion %”

I’m new to eazyBI so I tried something like this:

CASE
WHEN
Not IsEmpty ([Measures].[Issue Target Metric])
THEN [Issue].[Issue].GetMemberbyKey([Measures].[Metric Completion %]).get('Metric Completion %')
ELSE [Measures].[Story Points Completion %]
END

But it now returns only “Story Points Completion %” even if the Target Metric is not empty. Could you please highlight how THEN condition should be built to make it work properly? Thanks!

Screenshot 2024-02-21 at 14.51.14
Screenshot 2024-02-21 at 14.51.141230×624 99.5 KB

2

Hi @karina.krasik
If you have issues in rows, then you can use this formula:

CASE WHEN
Not IsEmpty ([Measures].[Issue Target Metric])
THEN [Measures].[Metric Completion %]
ELSE [Measures].[Story Points Completion %]
END

best,
Gerda // support@eazybi.com

3

Thanks, Gerda! The issue has been resolved

1 Like