Total Percentage in Table not calculated correctly

[ritasweidy]

Hello , 

Does anybody know how can i calculate the percentage column in order to show the right value in the Total in the "Table" View

Percentage = Difference / Last Year * 100

The Percentage on each row is working but when the "Table" is calculating the TOTAL Row, it is not calculating right

Branch	Last Year	Current Year	Difference	Percentage
LB	1500	2000	500	33.33%
QT	2000	4000	2000	100.00%
UA	3000	3250	250	8.33%
KA	4000	4500	500	12.50%
Total	10500	13750	3250	30.95%

[Stachu · Accepted solution]

The numbers I see in your example are correct, or do you expect to see something else?
Assuming they're correct, and that's your expected output - in general the formula is correct, but will only work if you create measure, you will also need to aggregate the columns with SUM

Also I would suggest using DIVIDE, as it has the proper DIV/0 handling, so

PercentageMeasure=DIVIDE(SUM(Table[Difference]),SUM(Table[Last Year]))*100