[brand]

Agreed. You'd be simply creating a composite value; your statements might look messy, but there's nothing stopping you from doing this with SQL.

Additionally, you're still choosing arbitrary values, and there are still going to be data points 'just outside' your selection - it may be more smooth, but it's just a weighting of the same metrics.