Hi Cédric,

Not sure what your formula looks like, but here a few functions that could be helpful
 

If you have a concrete example, I’ll be happy to guide you further.

Hope this helps!

I have a metric using the below dimension named “ Compte comptable” but i want to exclude the “Compte comptable” starting by 5123xxx, how can I combine the 2 functions you mentioned to do so  ? 

How about MetriccEXCLUDE: STARTSWITH("5123", 'Compte comptable'.Name)]?
You could also add a specific boolean property in your dimension and use that for the exclusion MetriciEXCLUDE: 'Compte comptable'.'Compte 5123xxxx']

I’m assuming you want to filter the data, not the view

I tried the first formula, i have no error but when i run the formula but i still have the 5123xxx accounts.

The dimension items will always be present in your dimension, but using your formula, they should not return any data.

If you don’t wish to see them in your view, you can simply hide them using the filtering options:

As they’re empty, you will not see them once hidden.

Hope this helps.

I already have this filter apply but i still have some value displayed.
 

Hi again, I believe you might have got the arguments in the wrong order, please try:

[EXCLUDE: startwith( “5123”, 'Compte comptable'.'Account number')]

The function begins with the value to find, then the data range to search.

It’s working well :) 
Thanks for your help