Exclude all the accounts starting by 5123xxxx

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 Metric[EXCLUDE: STARTSWITH("5123", 'Compte comptable'.Name)]?
You could also add a specific boolean property in your dimension and use that for the exclusion Metric[EXCLUDE: '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.
 

It’s working well :) 
Thanks for your help