Table calculation is always tricky, but here is my approach.
To conslidate "others" into one value, change the formula as below.
dynamically change dimension name.
When sorted, keep "Other" to the bottom.
Filter only one dimension on "Others"
Set Table calculations
Change filters to "Context" for LOD to work after diltering.
Thank you so much, I never would have come up with this on my own!
You are very welcome.