Measure or Column?

[Anonymous]

I'm trying to decide if it is best to create a column or measure in this situation. I have this formula and table that counts the amount of active clients a person manages:

 From here, I simply want to create a measure or column that places them into different tiers based on this criteria:

The tiers will be used in additional formulas that will be referenced... 'If Tier = 'x', then... but I'm just not sure if a measure or column is the best approach. Thanks!

[Greg_Deckler · Accepted solution]

Well, I would use a SWITCH statement, but it really kind of depends on what you want to do with it. If it doesn't need to be dynamic (as in re-calculated on the fly as the user interacts with things), then a column is generally more flexible than a measure, can be used in slicers, etc. If it needs to be re-calculated depending on user interaction, then you need to make it a measure.