Table Visual - filter out row with highest or lowest value (remove 1 row from the visual)

[DJBAJG]

I'm creating a report showing sensitive financial data. If users are able to select a certain number of groups and then vary that group by 1 they may be able to back into financials for a specific group.

To avoid that I want to create a filtering mechanism that always removes the row in the visual with the highest or lowest value regardless of what groups or how many groups the user chooses from the slicer. I've added a random number to each row of data and will use that as the driver of the filter. 

For example, the user selects 10 groups from the dropdown slicer. I want the table visual to dispaly 9 groups with the excluded group being the one with the highest or lowest random number associated with it. 

Lest you think this is as easy as a TOPN filter, keep in mind it needs to scale for any number of groups selected. If the user selects 47 groups the visual needs to dispaly 46.

The solution doesn't need to be eactly this but what it does need to do is somehow remove a selected value from the visual. Idealy, I'd like it to randomly remove one value but I couldn't even begin to understand how that would work.

Thanks. 

[DJBAJG · Accepted solution]

If you want something done right....

Big props to.... me. This was way easier than I thought it was going to be. Really amazed the community couldn't come up with this.