A left outer join keeps every row from the Explore base and adds matching customer attributes. Orders whose customer key is missing or unmatched produce null customer fields. Switching to an inner join removes those orders and can reduce revenue without any explicit status filter. Compare the joined report with the base order total, especially when a business user asks for all orders.
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.
Preserve orders without a matched customer.