Need help with calculated measures

Questions & Answers
1

I want to create a calculated measure that will return ‘1’ if the Issue Created Date is not empty else It will return ‘0’. I tried following logic with no luck. It return string ‘mmm dd yyyy’
CASE
IsEmpty(
[Measures].[Issue created date])
WHEN CBool(1) THEN ‘1’
WHEN CBool(0) THEN ‘0’
END

Thank you

2

Welcome to the EazyBi community,

There are some great support people here.

I am still learning myself, but maybe try the following:

CASE
WHEN NOT IsEmpty([Measures].[Issue created date]) THEN 1
ELSE 0
END

This should return 1 if the Issue Created Date is not empty and 0 otherwise.

3

Hi,

I wanted to follow up and let you know that you can check out this post for answers:

Best regards,
Ilze