I'm a bit confused about the goal - your data dimension Name has 3 values - All - Car - Bike and it sounds like when you want to see Bike you select Bike, like wise when you want to see Car you select Car and when you want the values associated with the dimension value All you do not want to see a summation of bike and car but you want to see the values in the table related to ALL -
That sound like you want to use a parameter based on name and tie it to a filter
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.
All_Secletions_v2018.1.twbx 19.0 KB