Keep getting error messages when I combine Calculated Members with Filters

Ese Djetore August 24, 2017

So, I have been trying to combine Calculated members with Filters in EazyBi but I keep getting error messages whenever I use the MATCHES filter.

 

The following is what I am trying to achieve;


Filter (
[Project.Category].[All Projects by category].Children,
[Project.Category].CurrentMember.Name MATCHES '*.infra.*'

but I keep getting a bunch of errors;

Formula is not valid: 
Member expression 'Filter([Project.Category].[All Projects by category].Children, ([Project.Category].CurrentMember.Name MATCHES "*.category.*"))' must not be a set

OR when I use .members in place of .children, I get;

Formula is not valid: 
More than one function matches signature '<Member>.Members'; they are: <Hierarchy>.Members, <Level>.Members

I'm trying to filter my project categories, so that, it returns results that match anything containing 'infra'.

Please, can someone kindly let me know what I'm missing...

1 answer

1 accepted

0 votes
Answer accepted
eazyBI Support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 25, 2017

Hi,

 

In this case, try the following code for your calculated member

 

Aggregate(
Filter(
[Project.Category].[Category].Members,
[Project.Category].CurrentMember.Name MATCHES '.*infra.*'
)
)

 

It will aggregate a set of categories that have "infra" in their name into a new calculated member.

 

Note it must be saved in the correct hierarchy.

 

definition of project calculated member .png

 

Please reach out to support@eazybi.com if you have further questions about this!

 

Kind regards,

Martins / eazyBI support Team

Ese Djetore August 25, 2017

Thanks, I tried the suggested code and it gave the result that I was looking for.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events