Filter table to show just the highest value AND the lowest value?

[chadstonks]

Is there a way to filter a slice so that it only shows two rows, one with the highest value in a given column, and one with the lowest? 

I'm not sure how to write an expression that does this.

[dbaum · Accepted solution]

IN([ID], MAXROW("Table", "Column") + MINROW("Table", "Column"))

Edit: I overlooked the detail of creating a list comprising the values returned by MAXROW and MINROW. I assume my original draft didn't work, but this updated version would:

IN([ID], LIST(MAXROW("Table", "Column"), MINROW("Table", "Column")))