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!

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

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.