PowerBI RateOptimization:Summary report shows wrong numbers

[RolandKrummenacher]

🐛 Problem

The Summary tab in the Rate Optimization Dashboard appears to use inconsistent formulas for identical metrics.

👣 Reproduction Steps

1. Set up the FinOps Hub, including the price sheet import.
2. Run the Rate Optimization Power BI report.
3. Compare the numbers in the screenshot; they do not match.

🤔 Expected Behavior

• List Cost - Contracted Cost should equal Savings from Negotiated Discounts.
• Savings from Negotiated Discounts + Savings from Commitment Discounts should equal Total Savings.

📷 Screenshots

ℹ️ Additional Context

• Savings from Negotiated Discounts seems to be calculated only for records where List Cost > Contracted Cost.
• Applying a where condition like ChargeCategory == 'Usage' might resolve the issue.

🙋‍♀️ Request for Community Help

We'd appreciate your support:

1. Upvote this issue (👍) to help us prioritize it.
2. Share your insights in the comments to refine the solution.

---

Let me know if you need further adjustments!

[josesarsa]

How did you do the price sheet import?
@RolandKrummenacher

[RolandKrummenacher]

How did you do the price sheet import? @RolandKrummenacher

I've exported the price sheets of the last 11 months via cost management export as described in https://microsoft.github.io/finops-toolkit/hubs/configure

[RolandKrummenacher]

The problem is most likely related to the reservation / savings plan purchase records:

[flanakin]

There are a number of scenarios where costs are missing in the data we get from Cost Management. We need to do some more work to handle those scenarios. That said, we can definitely clean up this query to work around them. Thanks for reporting this!