I have a measure that has extreme outliers, I determined that any value over 3288 should not be included so I created a calculated field that said " IF AVG([Measure]) < 3288 THEN AVG([Measure]) ELSE NULL END" and converted it to continuous.
Now id like the take those remaining values (those under the 3288 limit) and normalize them to a scale of 0-100 or 0-1. The formula I should use is x - Min(x) / Max(x) - Min(x), but when i try that it says since my measure is already aggregated I cannot aggregate it again.
Does anyone have a solution to this issue?
There is definitely a way to do this, but it's really hard to provide a good answer without being able to take a look at your data or your Tableau workbook. Any chance you can upload a packaged workbook?