Generate Set from a string

Hi,

I have a problem with one of my reports. What I want to do is to count Fix versions by month, but with a slight catch. We have multiple releases that have the same release number as a part of their name, like this:

  • AN 5.1.1 New links
  • AN 5.1.1 Bugfixes
  • AN 5.1.1 New feed

    When we create our report, those Fix versions are counted separately - which is expected, but we would like to count all that have the same number as a single release.

What we tried is to create a custom calculated measure:
StrToSet(
Generate(
Filter(
Descendants([Fix Version].CurrentMember, [Fix Version].[Version]),
DateInPeriod(
[Measures].[Version release date],
[Time].CurrentHierarchyMember)
AND
[Fix Version].CurrentMember.Get(“Status”) <> “Unreleased”
AND
[Fix Version].CurrentMember.Name MATCHES “AN .*”
AND
([Measures].[Issues created], [Time].CurrentHierarchy.DefaultMember) > 0
)
,
ExtractString([Fix Version].CurrentMember.Name, ‘\s+([^\s]+)’, 1),
', ’
)
, WHAT TO PUT HERE???)

The idea is that we can get all Fix versions in a period, extract the version part of the string from the Fix version name, put that back as a set, remove duplicates and count remaining members.

But we can’t get StrToSet to work and we can’t find any docs around this - any help or better suggestion on how we could achieve this?

Kind regards,
Bruno