Set expression: string does not begin with, and is different from

[BartVA]

Hello,

I need a set expression where, in plain English, " 'Name' does not begin with '&' and is different from '9999' too".

I also need it to filter a Master Dimension, like this: if ( 'Name' does not begin with '&' and is different from '9999' too", Name)

Can someone give me a hand please?

Many thanks in advance!

[Saravanan_Desingh · Accepted solution]

If(Not WildMatch(Name,'&*','9999'), Name)

[Vegar · Accepted solution]

You can eliminate values that starts with % and the value 9999 using set analysis by using a -= set modifier like below.

Only({< Name-={"%*",'9999'}>}Name)

[BartVA]

Thank you @Saravanan_Desingh and @Vegar !