String Format of a generated filter

Questions & Answers
1

Hi guys,
I have a generated filter with cases. I would like to have the result as “xxx, www”. If I generate the filter without the cases before ", ‘,’ " works. But if I add the cases to remove some not needed results, it doesn’t work. How can I have the filter result with a comma?

CASE

WHEN [Measures].[Issue type]=“Concept Deliverable”
THEN
Generate(
Filter([Validation method].Members,

([Measures].[Issues created],
[Logged by].DefaultMember)>0

),

CASE [Validation method].CurrentHierarchyMember.Name
WHEN “(none)” THEN “”
WHEN “All Validation methods” THEN “”
ELSE
[Validation method].CurrentHierarchyMember.Name
END

)
END

I would like to have
ELSE
[Validation method].CurrentHierarchyMember.Name, ‘,’
END
But I get a syntax error.

2

Hi @Christine,

You should add all the conditions within the Filter(…). The Generate(…) is only formatting the result of the set you have already filtered.

Please try the following:

CASE
  WHEN [Measures].[Issue type]="Concept Deliverable"
THEN
Generate(
  Filter([Validation method].[Validation method].Members,
    ([Measures].[Issues created],
     [Logged by].DefaultMember)>0 AND
     [Validation method].CurrentHierarchyMember.Name <> "(none)"
  ), [Validation method].CurrentHierarchyMember.Name, ", "
)
END

Lauma / support@eazybi.com

1 Like