Is it possible to show the number of results somewhere on a dashboard when using <columnName>::filter Query filters?

You could use a Counter visualization and toggle the Count Rows option.