COALESCE substitutes a fallback only when the original expression is null. Use it when the business definition explicitly treats missing revenue as zero. A zero already has a value and should stay zero. Changing all low values to the same fallback would alter valid observations. Read the source rows with null revenue and compare their calculated values before aggregating them.
Use the field picker and the generated result together. The warehouse contains repeated customer keys, orders with several items and missing values. Those rows make a plausible-looking total insufficient evidence. Run the requested definition, inspect its grain, and use the feedback to locate the mismatch. Every dataset here is fictional.
Distinguish a missing value from a zero.