Ponderation

[Anonymous]

Hello. I have a table for sellings like this:

Product	%	Montly var
Hammer	20	-33%
Cutter	17	6%
Others	73	90%

In the cell % I have the total, but with the option "show as porcentaje". The thing is that the Monthly var is calculated against the total, I want it to be calculated against the % of the total.

How can I make a measure that equals the "Show as %" option to work agains it?

Thanks

[Anonymous · Accepted solution]

Solved.

With 

%TotalSells = DIVIDE([Total Sells], CALCULATE([Total Sells], ALL(Products[all_products])))

I have the measure to show the %s. I made a MoM quick measure over it and got the needed result.

Thanks!!