% of total

Hi,

I know I can do this with a quick calc but wanted to be able to name the column and format the percentage.

I've followed another example but my rows are always 100%

Import % of Total = var bigTotal = SUMX(ALL(WCG_CONTRIBUTION[Site]), CALCULATE(SUM(WCG_CONTRIBUTION[Actual])))
return DIVIDE(SUM([Actual]),bigTotal)

My data is basically:

Site Actual

AA  1000

BB  200

CC 100

Etc

All I want is for each site to have the % of total but with the above get 100% for each row.

Please help me!!!

Thanks