A sum measure adds row-level values inside each Explore group. Put revenue minus cost in its SQL expression to calculate total profit. A count of that expression only counts non-null rows; an average produces profit per order. Both may look plausible in a small report. Read the measure type together with its SQL, because neither part alone defines the business metric.
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.
Aggregate profit once at the correct grain.