see the attached approach using sets (since you did not include a twbx workbook I used superstore data using sub category as a proxy for you name field )
first I created a parameter to select a subcategory
then used this formula for sales - sum of the selected sub cat and the average of the sum for others
it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.