it depends on what exactly you are trying to accomplish. If the only goal is to filter one or two visuals to this level, then I recommend applying a filter to the visual itself using the filter pane.
In this screenshot, I have added a filter to the “Filtered” visual, there is no filter on the “Unfiltered” visual.
NOTE: even If you are going to hide the visual pane for the end user, you can use it to filter the visuals for your own purposes.
Another option is to create a measure that only shows sales that are over a certain total - I like to do this by branching my measures, so in this case I have two different measures:
NOTE: the measure solution requires an additional trick to ‘fix’ the total - because the total is over my limit, so it will show with the example above.
If you need to use the number as a filter amount for the USER to select, then you may want to use a calculated column (which I think is what you are describing above - without seeing your model it’s hard to tell).
