I would love to be able to count up the number of deals that have a value greater than or equal to $1,000,000. In the example data attached, the number of deals fitting this criteria is 5.
This metric will be used as part of a bigger dashboard with date parameters etc. I have gotten 95% of the way there but getting the COUNTDistinct to display as a single figure with everything else hidden from display is proving difficult. I'm sure I have over-complicated it to date, all help is very welcome.