This can be done by changing the calculation to look like the following:
if sum([Sales])>[Threshold] then 1 else 0 end
Then, place this on the level of detail shelf. Right click on it and make sure it is set to Continuous. Right click on it again and select Filter, then filter to 1. Hope this helps!
1 of 1 people found this helpful
Thanks for your response, it's perfect and does exactly what I needed.