sql_always_where adds a condition to every query of the Explore. Use it for a documented population rule that report authors must not remove. An always_filter is visible and its value can be changed; it solves a different need. A permanent condition applies before aggregation, so it also changes totals. Explain the restriction in the model documentation before colleagues reconcile this Explore with the unrestricted warehouse.
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.
Keep incomplete orders out of a governed Explore.