Calculated column for Percentage gives wrong total percent

[Sravs_basf]

Current/Current-Target for the total->543/638= 85%
but the calculated column Current% is just adding all the percents in the rows.
Any idea on how to change this would be great!

[v-kkf-msft · Accepted solution]

Hi @Sravs_basf ,

Please try a measure instead of calculated column.

Measure = DIVIDE( SUM( 'Data Owner Agreed'[Current]), SUM( 'Data Owner Agreed'[Current-Target]))

Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Samarth_18]

Hi @Sravs_basf ,

Please take the avg of your newly created column as below:-

Thanks,

Samarth