I would like to be able to do SUM DISTINCT of a numerical field to sum based on the distinct values of another field (a distinct key, like order_id).
This is an available measure type in Looker: Measure types | Looker | Google Cloud
And this is further described here: sql - Sum distinct by separate ID column - Stack Overflow