List various text in one measure from various fields

Questions & Answers
1

I have 12 individual custom fields for resource #1, resource #2, resource #3, and continued until resource #12. Is it possible to display all of the names from these fields into one calculated measure?

image
image849×489 31.5 KB

2

Hi @Alyssa_A

Try creating a new calculated measure where you concatenate all 3 measures together in one string.

CASE WHEN
Not IsEmpty([Measures].[Issue assignee])
AND
Not IsEmpty([Measures].[Issue reporter])
THEN
[Measures].[Issue assignee]||
chr(10)||[Measures].[Issue reporter]
END

That will split them in new lines.
You can also try a similar code:

CASE WHEN
Not IsEmpty([Measures].[Issue assignee])
AND
Not IsEmpty([Measures].[Issue reporter])
THEN
[Measures].[Issue assignee]||","||[Measures].[Issue reporter]
END

This last code would generate them in the same line - one comma-separated string.
Martins / eazyBI

image
image1920×942 94.9 KB

1 Like
3

Thank you so much, this was successful. If the fields are “None”, how can I not display those as they resulted in “(none)”?

image
image767×573 13.4 KB

CASE WHEN
Not IsEmpty([Measures].[Issue Resource #1])
AND
Not IsEmpty([Measures].[Issue Resource #2])
AND
Not IsEmpty([Measures].[Issue Resource #3])
AND
Not IsEmpty([Measures].[Issue Resource #4])
AND
Not IsEmpty([Measures].[Issue Resource #5])
AND
Not IsEmpty([Measures].[Issue Resource #6])
AND
Not IsEmpty([Measures].[Issue Resource #7])
AND
Not IsEmpty([Measures].[Issue Resource #8])
AND
Not IsEmpty([Measures].[Issue Resource #9])
AND
Not IsEmpty([Measures].[Issue Resource #10])
AND
Not IsEmpty([Measures].[Issue Resource #11])
AND
Not IsEmpty([Measures].[Issue Resource #12])
AND
Not IsEmpty([Measures].[Issue Resource #13])
AND
Not IsEmpty([Measures].[Issue Resource #14])
THEN
[Measures].[Issue Resource #1]||", “||[Measures].[Issue Resource #2]||”, “||[Measures].[Issue Resource #3]||”, “||[Measures].[Issue Resource #4]||”, “||[Measures].[Issue Resource #5]||”, “||[Measures].[Issue Resource #6]||”, “||[Measures].[Issue Resource #7]||”, “||[Measures].[Issue Resource #8]||”, “||[Measures].[Issue Resource #9]||”, “||[Measures].[Issue Resource #10]||”, “||[Measures].[Issue Resource #11]||”, “||[Measures].[Issue Resource #12]||”, “||[Measures].[Issue Resource #13]||”, "||[Measures].[Issue Resource #14]
END

4

Hi,

Try this approach now:

CASE WHEN
[Issue].CurrentHierarchyMember.level.name = "Issue"
THEN
Generate(
  Filter(
  {
[Measures].[Issue Resource #1],
[Measures].[Issue Resource #2],
[Measures].[Issue Resource #3]
},
   CoalesceEmpty([Measures].CurrentMember, "(none)") <> "(none)"
   ),
   CAST([Measures].CurrentMember as string), ","
)
END

Martins / eazyBI

5

This seems to return no results for me

6

Try this formula now:

Generate(
  Filter(
  {
[Measures].[Issue Resource #1],
[Measures].[Issue Resource #2],
[Measures].[Issue Resource #3]
},
   CoalesceEmpty([Measures].CurrentMember, "(none)") <> "(none)"
   ),
   CAST([Measures].CurrentMember as string), ","
)

Martins /eazyBI

1 Like