PowerBI Scorecards : issues on aggregation

[AlainChev]

Hi,

I have built a Scorecard report on PowerBI. I have created a goal for which : 

• the current value is the sum of the secondary goals : it works well.
• The target value is the sum of the secondary goals as well : this is where I have an issue : the SUM amount is not correct.

I have checked manually the sum and it should be way higher than that. All the secondary target values are input manually and have been triple checked, and are in the format "Whole number". You will find below screenshots for better understanding of the issue. I don't understand where the issue comes from exactly, but it looks like the system creates Multiple goals by itself. 

Here are some screenshots with explications :

The SUM current value calculated from subgoals is correct. The SUM Final target value calculated from subgoals is incoherent.

When trying to edit the Final target field, I do not have the option to switch to Manual goal, I don't understand why.

Finally, when I go in "Multiple targets" , I see that there are numerous incoherent multiple targets that are visible. I did not create these, and when I delete them, they systematically come back. and at the bottom, here it is, we can find the 5.5K figure that the system loads as my target, even when I do not asked for it.

I hope I described my issue in a way that allows to help or open an issue 🙂

Thanks in advance for your help.

Cheers.

Alain

[OldDogNewTricks]

I have some related ideas here, feel free to vote:  Scorecard updates - Microsoft Fabric Community

[AlainChev]

Hi @v-tsaipranay 

Thanks for your detailed answer.

I suspect that the data set behind gets corrupted at some point. On Scorecards, there is little control on the data set. I will dig into the connections to other data sources.

In the meantime I have recreated the goals from scratch, and I think I isolated a behavior : when there is more than 4 sub goals, the SUM function of the master goal target returns an incoherent value. However the MIN or MAX function work well. Also the SUM function of the current value of the master goal works well even when there is more than 4 sub goals.

I will workaround this !

Cheers.

Alain

[v-tsaipranay · Accepted solution]

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.