Percentage of total "metric"

[bolabuga]

Hello everyone, 

Needing help making a metric for "percentage of total". There sample table. im not understaning how should i make a metric for summing a month and diving the result for the summing of "all" months.

	money	%
jan/15	780	32,02%
fev/15	315	12,93%
mar/15	318	13,05%
abr/15	1023	42,00%
total	2436

REFER	MONEY
jan/15	10
jan/15	20
jan/15	30
jan/15	40
jan/15	50
jan/15	60
jan/15	70
jan/15	80
jan/15	90
jan/15	100
jan/15	110
jan/15	120
fev/15	30
fev/15	39
fev/15	48
fev/15	57
fev/15	66
fev/15	75
mar/15	48
mar/15	69
mar/15	90
mar/15	111
abr/15	48
abr/15	57
abr/15	66
abr/15	75
abr/15	84
abr/15	93
abr/15	102
abr/15	111
abr/15	120
abr/15	129
abr/15	138

[bolabuga · Accepted solution]

I Found the solution for my own question here:

http://community.powerbi.com/t5/Desktop/percent-of-grand-total/m-p/59033#M24188

I should have searched more before posted :(.

[bolabuga · Accepted solution]

I Found the solution for my own question here:

http://community.powerbi.com/t5/Desktop/percent-of-grand-total/m-p/59033#M24188

I should have searched more before posted :(.

[PavelR]

Hi @bolabuga

I would recommend using Quick Calc and then Percent of grant total option. So create metric like

SumMoney = SUM(Data[MONEY])

And then add it twice to table, then do as in pic below

1. Quick calc:

2. Percent of grand total

Outcome:

Regards.

Pavel

[bolabuga]

THKS PAVELIR, that solved the question and now im stuck at a newer related problem.

I thought the 1st question would solve my problem also for the subtotals, but its doing percentange of the grand total, and i need % of the subtotal in each years (like the total of each year is 100% and the summed % of the months of that year will be 100%).

I thought a slicer with year would solve the problem, but it keep showing the percentage related to grand total.

[bolabuga · Accepted solution]

Solution for the 2nd question in here:

https://community.powerbi.com/t5/Desktop/How-to-get-values-in-a-matrix-as-a-percentage-of-column-tot...