PowerBI Scorecards : issues on aggregation

Hi AlainChev ,
Thank you for reaching out to the Microsoft Fabric cummunity forum.

It sounds like the issue is rooted in how Power BI Scorecards handle goal structures and data aggregation. Since the secondary targets are manually entered as "Whole numbers" and verified, but the final target still shows an incorrect sum especially with unwanted "Multiple goals" appearing this is likely due to a data sync or misconfigured goal setup.

First, check the Scorecard’s target field settings to ensure it's set to "Sum" aggregation. If you can't switch to manual goal input, inspect whether the Scorecard is connected to a live dataset or report. If so, temporarily disable the sync from the Scorecard’s settings, then manually remove the extra goals under the "Multiple targets" tab. If these targets reappear, create a new measure in Power BI Desktop to sum the secondary targets (Total Target = SUM('Secondary Goals'[Target Value])), republish the report, and bind this measure to the target field in your Scorecard.

This should ensure the total aggregates correctly and prevent unwanted goal recreation. If the issue persists, rebuilding the Scorecard from scratch may be necessary to bypass any corrupted goal configurations.

Also please go the below documentation for detail limitations and considerations:

Create connected goals in Power BI - Power BI | Microsoft Learn

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you.