I know that gwassenaar is one of our star community members, so I am unsure if the answer I provide might be helpful or perhaps similar to what has been already provided. Have you looked into using the Dimension Limit feature for the Dimension value?
You can create a calculated expression related to the measure being used to limit the number of dimension values. Look at the input where the fx - symbol is - let me know how you do.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.