cancel
Showing results for
Did you mean: Frequent Visitor

## SUb total percentage value is wrong in table

Hi Expert,
My dataource Percentage column (already calculated and given percentage )but Power BI sub total showing wrong.

Eaach value its 100% but total is 300% showng.
expected is 100% only
sum of values should be less than 100% 1 ACCEPTED SOLUTION  Community Support

According to the logic in a matrix, the subtotal will sum up all child rows under their parent, so 300% is a correct result. However this is a percentage column, usually the actual meaning should be different. To get correct percentage subtotal values, we should use a measure rather than a calculated column in the matrix.

For example, if a percentage column is calculated with

% Column = DIVIDE('Table'[column A] , 'Table'[column B])

Then you need to create a measure to display in the matrix.

% Measure = DIVIDE(SUM('Table'[column A]) , SUM('Table'[column B]))

This is a simple example. If you can provide some sample data to show how this percentage column is calculated, we can try to provide more detailed suggestions.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

2 REPLIES 2  Community Support

According to the logic in a matrix, the subtotal will sum up all child rows under their parent, so 300% is a correct result. However this is a percentage column, usually the actual meaning should be different. To get correct percentage subtotal values, we should use a measure rather than a calculated column in the matrix.

For example, if a percentage column is calculated with

% Column = DIVIDE('Table'[column A] , 'Table'[column B])

Then you need to create a measure to display in the matrix.

% Measure = DIVIDE(SUM('Table'[column A]) , SUM('Table'[column B]))

This is a simple example. If you can provide some sample data to show how this percentage column is calculated, we can try to provide more detailed suggestions.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.  Super User

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided. Announcements #### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023. #### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers! #### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture. Top Solution Authors
Top Kudoed Authors
Users online (2,677)