Search specific text in Customer

Questions & Answers
1

Is there a way to select only a specific type of customers? There names all contains beside a description, also a unique code. 1 starts with “ABC”, the other starts with “DEF”.
eg: CUST1 - Customer1 - ABC1257899
CUST2 - Customer2 - DEF7854232…

I want to exclude those who have “DEF”

2

Hi,

It is possible to create aggregated members using the filter and pattern matching.

Aggregate(
Filter(
[Customer].[Customer].Members,
NOT [Customer].CurrentMember.Name MATCHES ‘DEF.*’
)
)

See here for more on how to create and use aggregated members in different dimensions:
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-members-in-other-dimensions#Calculatedmembersinotherdimensions-Aggregatemembersinotherdimensions

Kindly,
Janis, eazyBI support

3

@janis.plume

thank you it works, just changed the “DEF.*” syntax into “.DEF.”