Nobody built the
wrong dashboard
The monthly meeting where two people bring different numbers for the same thing is not a data quality problem. It is a definition problem, and it is expensive in a way that never appears on an invoice.
How it happens without anyone being careless
Finance builds a gross margin measure that excludes freight, because that is how the accounts treat it. Sales builds one that includes freight, because that is what shows up in the deal. Both are defensible. Both are documented somewhere. Neither person knows the other exists.
Six months later they are in the same meeting with figures that differ by a few points, and the next forty minutes are spent reconciling instead of deciding.
The cost is the meeting, not the number
The visible cost is time. The real cost is that the room learns to discount every number it is shown. Once that happens, people bring their own spreadsheet as insurance, which creates a third definition, and the platform is now actively producing disagreement.
The end state is an organisation with a large reporting bill and a culture of deciding on instinct anyway, because the instinct at least does not need reconciling.
Why discipline does not fix it
Every serious BI tool offers a way to do this properly. Shared datasets, certified models, a governed layer that analysts are supposed to build on. They work when they are used.
The trouble is that nothing stops somebody adding a new measure in a new report at four o'clock because they need a number for five. That path is always faster than the correct one, and it is available to everyone. A rule that competes with a shortcut loses on a long enough timeline.
Making it structural instead
The alternative is that there is only one place a metric can be defined, and every surface reads from it. The dashboard, the plain-English question, the export and the scheduled report all resolve gross margin the same way because there is no second definition available to them.
This is less flexible, and that is the point. The flexibility being removed is the flexibility to disagree with yourself.
Common questions
What if two definitions are both genuinely needed? Then both get defined, named distinctly, and both are available everywhere. Margin excluding freight and margin including freight are two metrics, not one metric with an argument attached. The failure is unnamed variants, not multiple ones.
Does this stop analysts exploring? No. Exploration on top of governed definitions is fine and should be easy. What it stops is a private redefinition becoming the basis of a report other people rely on.