Want to calculate % based on the values in total as well

[jay_patel]

Hi All,

Below is the scenario. here, i have applied calculation i.e., B/A*100 which is working fine for all rows but i want to get % value in total based on the total of Column A & B.

Column A	Column B	%
88	78	88.63636364
62	55	88.70967742
22	18	81.81818182
90	67	74.44444444
111	67	60.36036036
200	180	90
573	465	81.15183246

Desired Value in total is 81.151 which came by dividing sum of B by sum of A. but in power bi how to get that value (81.151) in total as well.

Thanks in advance

[Anonymous]

Hi @jay_patel 

I guess your current % is a calculated column so it doesn't work correctly to get the total when you add it to a table or matrix visual in the report. To get the correct total, you need a measure instead. You can try the measure suggested by @Arul then format it to percentage. 

To learn how Power BI calculates total and subtotal values in tables and matrices, please refer to Understanding how Power BI calculates totals 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[Arul · Accepted solution]

@jay_patel ,

Can you try this in measure?

% = SUM(TableName[Column B])/SUM(TableName[Column A])