how to calculate the percentage of the grand total in power bi desktop

[vijayghatti]

Hello Friends,

i am new to Power BI and started exploring the features of power BI. i am stuck on understanding how to dervice the percentage of the grand total.

my case is as below

I have the below  table

Description	No of Units	Units Sold	Percentage of units Sold
1	286	252	88%	Created a custom calculated column and the values are coming correctly
2	253	177	70%
3	90	51	57%
4	11	4	36%
5	2	1	50%
6	1	0	0%
Grand Total	643	485	75% (485/643)	This is not being calculated correctly in Power BI, it  shows either 100% or sum of the values.

please help me.

[Anonymous · Accepted solution]

Make your Percentage of units Sold a measure an use this formula:

Percentage of units Sold = sum('TableName'[Units Sold]) / sum('TableName'[No of Units])