NonEmptyString
EAZYBI Returns the string if it is not empty (contains at least one character), otherwise returns an empty result. Used to convert an empty string value to an empty result. If the IsEmpty function is called on the result, it will return 'true' for this empty result.
Syntax
NonEmptyString(String_Expression)
Arguments
| String_Expression | MDX expression that returns a string. |
|---|
Examples
List of all issue assignees
The following formula can be used to return a comma-separated list of users who have been assigned to the issue at any point. The NonEmptyString is applied to the Generate function to convert the empty string value to an empty result, so that if another measure uses the IsEmpty function on this result, it would work as expected.
NonEmptyString(
Generate(
Filter(
Descendants([Assignee].CurrentMember, [Assignee].[User]),
(
[Measures].[Transitions to assignee],
[Time].CurrentHierarchy.DefaultMember
) > 0
AND
[Assignee].CurrentMember.Name <> '(unassigned)'
),
[Assignee].CurrentMember.Name,
', '
)
)
See also
- Function IsEmpty returns 'true' if there is an empty result or 'false' if there is a result.
- Function Generate returns a concatenated string created by evaluating a string expression over a set.