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