Why Finance, Ops, and Sales Each Have a Different Number (and How to Fix It)

Finance walks in with a slide. Ops has another. Sales has a third.

They all say “revenue.” None of them match.

The first twenty minutes of the meeting go to whose number is right. The decision that needed a number waits.

That is not a Power BI bug. The dashboard is doing what it was told. The business never agreed what the number means, where it comes from, or when it last refreshed.

The search is real. People type “why do Power BI reports show different numbers” and “why does every department have a different number.” 2026 articles on Datilog, Solv, DataCult, Colrows, and EPC Group target those questions. Those writers sell adjacent products. Treat the diagnosis as industry judgment, not Alluvium research.

Why three numbers

Three honest calculations. Three different jobs.

Definition. Finance books net, after returns and credit notes, on posting date. Sales counts bookings on order date, often including open orders. Ops counts what shipped and invoiced. Each is a real business concept. None of them is “wrong.” The title on the slide just says revenue.

Source. Sales trusts the CRM. Finance trusts the ERP. Ops pulls from the warehouse or the plant system. Each system holds a partial picture. Each department trusts the system it lives in.

Refresh. One report ran this morning. One is last Friday’s extract. One is a workbook someone updated three weeks ago. Same definition, same source, still three numbers.

You feel it as three slides, not as a data-quality ticket. Nobody is lying. The meeting is the symptom.

That split—definition, source, refresh—is the same three-way diagnosis vendor blogs keep publishing. Solv, Datilog, and DataCult all lead with some version of it. If you cannot say which of the three is off, you will rebuild the wrong layer.

If the number is drifting because someone pasted an ERP dump into a workbook, that is a different fight: keep shared actuals in the model and stop pasting. This piece is the other half. Finance, ops, and sales walking in with three honestly-built views.

If the estate is a mess of copies, owners, and access, that is the operating system. See The Hidden Costs of Poor Power BI Governance. This post is the meeting, not the catalog.

If nobody can say which decision the number is for, that is strategy, not a chart. See Why Your Power BI Strategy Isn’t Delivering.

The costs of three slides

1. The meeting starts with reconciliation. Time that should go to a decision goes to “can you check this figure.” Leaders leave with an action to align the numbers, not an action on the business.

2. Trust dies first. Once a CFO has been burned in front of the room, the next dashboard gets a shrug. Data becomes something you argue with, not something you use. That is a leadership problem before it is a chart problem.

3. Analysts defend instead of analyze. The people who built the reports spend the week explaining grain, date, and exclusions. Insight waits.

4. Real problems look like noise. A margin collapse and a filter mismatch get the same sceptical response. You cannot escalate what you cannot trust. Late insight on the line is a different bottleneck: Every Minute Counts.

5. Everyone builds a private number. If the shared report cannot win the meeting, each function keeps its own. Effort duplicates. The next month’s slides disagree again.

Slow or unused dashboards are a different job: dashboard optimization. A finance team still assembling the pack by hand is a different job: Power BI consulting for finance reporting.

How to fix it (start with one metric, one owner)

You do not need a steering committee. You need one number the room will argue from, then a loop that holds.

1. Pick the metric leadership already fights about. Usually revenue, margin, backlog, or on-time. Write a name on the wall. Appoint one owner who can say yes or no when the definition changes. Not a committee. One name. Start with the fight you already have. Do not inventory every KPI first.

2. Write the definition on one page. Date field. Source system. Inclusions and exclusions. Currency. Grain. Refresh window. Who uses it for which decision. DataCult calls this a KPI contract; Datilog lists the same fields. The label does not matter. The page does. If “revenue” still means three things, name them: booked, invoiced, shipped. Do not hide three questions under one title.

3. Put the calculation in one place reports can reuse. In Power BI that is a semantic model other reports connect to, not a measure rewritten on every page. Change it once. Every slide moves together. You do not need a full catalog, a CoE, or a six-month migration to get this far. One official measure. Reports consume it.

4. Agree the as-of. Same refresh cadence for the meeting pack. Stamp the time on the slide. A morning refresh and a Friday extract are two clocks, not two truths. Match cadence to the decision. See 10 Things Every Small Business Should Know When Starting with Power BI.

5. Retire the competing slides. If last month’s version stays in the deck, the argument stays with it. One view for the room. Departmental detail can exist. It cannot contradict the number the ELT will use. Sunsetting abandoned copies is governance work; the instinct is the same as in the governance post. Do the retirement on this one metric first.

6. Prove it in one meeting. One metric. One owner. Same number on finance, ops, and sales slides. If that loop still disagrees, do not scale it. Find which of the three—definition, source, refresh—broke. Then fix that. Definitions that need a company-wide map, not a one-pager, belong in a Data & AI Strategy Roadmap. Ongoing ownership of those definitions is Managed Data & AI Advisory.

Frequently asked questions

Why do Power BI reports show different numbers? Usually because they use different definitions, different source systems, or different refresh times. The visual is often fine. Start there before you rebuild models.

Why does every department have a different number? Each function answers a slightly different question and trusts the system it runs. Finance, sales, and ops can all be internally correct. The company never picked one definition for the decision in the room.

Is the dashboard lying? Usually no. It is calculating what it was asked. Three asks, three answers.

Do we need a new platform to fix this? No. You need an agreed definition, one reusable calculation, and a refresh the meeting can trust. Tooling helps. It does not replace the agreement.

Should we force one revenue number for every use case? No. Booked, invoiced, and shipped are different questions. Name them. Do not put three meanings under one title. Use one official number for the decision the ELT is making.

How is this different from Power BI governance? Governance is the framework: owners, catalog, access, sunsetting abandoned reports. This is the meeting symptom. Do the one-metric fix first. Then put the framework under it.

What if Excel is still in the chain? If the workbook is pasted actuals, stop pasting. If it is a forecast or a formatted pack, that is a different article. This one is three departments, three honestly-built numbers.

Get started with Alluvium

You do not need every KPI governed on day one. You need one number the next ELT meeting will not fight.

Need a 30-minute look at why finance, ops, and sales still walk in with three slides? Contact Alluvium. We’ll map one metric, one owner, and the definition/source/refresh split—not a reporting overhaul.

Book a 30-minute consult.