Wrong ESR Calculation after moving from EA to MCA in Rate Optimization #2235

Activity

1. microsoft-github-policy-service

   added

   Needs: Triage 🔍Untriaged issue needs to be reviewedUntriaged issue needs to be reviewed

   on Aug 4, 2026
2. microsoft-github-policy-service commented on Aug 4, 2026

   

   microsoft-github-policy-serviceBot

   on Aug 4, 2026 – with Microsoft GitHub Policy Service

   More actions

   Thank you for submitting this issue! We try to respond within 3 business days. In the meantime:

   • 📖 Check the troubleshooting guide for common issues
   • 💬 Ask questions in Discussions
   • 📅 Join our biweekly office hours for live help from the team
3. flanakin commented on Aug 26, 2026

   

   Michael Flanakin (flanakin)

   on Aug 26, 2026

   Collaborator

   More actions

   🤖 [AI] Thanks for the report. This looks like the same underlying mechanism tracked in #2214: rows carrying a real EffectiveCost with ListCost missing or equal to it (common on amortized/reservation and Marketplace rows — and EA→MCA migrations tend to surface more of these) collapse the per-row savings calculation and skew ESR.

   We're tracking the fix in two parts:

   • fix(hubs): Fix Data Explorer dashboard savings formulas and exclude commitment purchases #2248 — dashboard-side fix (ADX dashboard tiles summing raw cost instead of the already-clamped savings column), currently in review
   • Fix ingestion-side ListCost repair gaps for ESR/savings accuracy (defects 2-4 from #2214) #2286 — ingestion-side fixes (why some of these rows never get repaired in the first place, plus data-provenance gaps)

   Closing this as a duplicate of #2214 to keep the investigation in one place. If you have a specific export/hub where you can confirm ListCost == EffectiveCost on the affected rows, adding that data point to #2214 would help — otherwise we'll follow up here if we need MCA-specific repro details.
4. Michael Flanakin (flanakin)

   added

   Resolution: DuplicateThis issue or pull request already existsThis issue or pull request already exists

   Type: Bug 🐛Something isn't workingSomething isn't working

   Tool: FinOps hubsData pipeline solutionData pipeline solution

   and removed

   Needs: Triage 🔍Untriaged issue needs to be reviewedUntriaged issue needs to be reviewed

   on Aug 26, 2026
5. Michael Flanakin (flanakin)

   closed this as not plannedon Aug 26, 2026