ISEmpty Logical Expression

Questions & Answers
1

Our Admins have created a new field for SLAs as translation of the english names.

The old name is ‘Time to resolution Elapsed hours’ the new name is ‘Lösungszeit Elapsed hours’.

Now I´m trying to create a calculated measure that displays the old value when is not empty, else should the new value be displayed.

Im trying this formula :
IIf( IsEmpty([Issue].CurrentHierarchyMember.get(‘Lösungszeit Elapsed hours’))=‘true’ , [Issue].CurrentHierarchyMember.get(‘Time to resolution Elapsed hours’)
, [Issue].CurrentHierarchyMember.get(‘Lösungszeit Elapsed hours’) )

But following error is being displayed:
image

What else an I do to display both values in the same column (calculated measure) ?

Many thanks in advance

2

@AntonBDR

Try this formula:

IIf( 
IsEmpty(
[Issue].CurrentHierarchyMember.get('Lösungszeit Elapsed hours')
), 
[Issue].CurrentHierarchyMember.get('Time to resolution Elapsed hours'),
[Issue].CurrentHierarchyMember.get('Lösungszeit Elapsed hours') 
)

Martins / eazyBI team

3

Hi @martins.vanags , when using your formula I get following error message:

image
image1300×110 15.6 KB

Thanks

4

Try using Case structure:

CASE WHEN
IsEmpty(
[Issue].CurrentHierarchyMember.get('Lösungszeit Elapsed hours')
)
THEN
[Issue].CurrentHierarchyMember.get('Time to resolution Elapsed hours')
ELSE
[Issue].CurrentHierarchyMember.get('Lösungszeit Elapsed hours') 
END

Martins / eazyBI

5

Thanks @martins.vanags , that worked!