So for my formula to determine the locations with the [Lowest Net Revenue] it is as follows:
Lowest Net Revenue = VAR RankingDimension = VALUES( 'Location Code'[Revenue Location]) VAR RankingSelect = [Lowest Ranking Select] RETURN CALCULATE( [Net Revenue], FILTER(RankingDimension, RANKX(ALL('Location Code'[Revenue Location]), [Net Revenue], , ASC) <= RankingSelect))
But what I notice is there are locations that I want to exclude because they are simply too new and would naturally in their first year have a negative net revenue but they would only be distinguishable by their name. At best, I could use the Location type column as a filter and do an ‘ALLEXCEPT’. But if I go from doing ‘ALL’ to ‘ALLEXCEPT’ how would that look in terms of the formula or does it even make sense to do it that way. I know I could always right click on the visual and exclude those locations that way but I want to try and keep everything rooted in formula logic.