Lens supports the unique.count function that does exactly what you want, and can be used in a formula.
In the screenshot below, using the Kibana Flights dataset, I create a Lens table that shows for each Carrier the count of destinations, the unique count of destination countries, and the normalized value with those two (not looking for any meaningful value here, just to show how it works)
