Calculated Member not Working With Excel Source Data

Given the attached Excel data source (which imports without error), why does the following calculated member fail generate a result set?

Aggregate(
Cache(
Filter(Descendants([Account Name].CurrentMember,[Account Name].[Account Name]),
[Account Name].CurrentMember.Name
MATCHES ‘.*common.*’)
)
)

I know what the expected result should be via the dimension bookmark feature (“common” occurs on one account name only). Lastly, I use this pattern/snippet successfully with the EazyBI-provided Issues cube.

Hi @AWPPMT

When defining the calculated member in the Account Name dimension, try using the following formula:

Aggregate(
  Filter(
    [Account Name].[Account Name].Members,
    [Account Name].CurrentMember.Name
    MATCHES ".*common.*"
  )
)

Best regards,
Nauris / eazyBI support

Works like a charm!

Very much appreciated.