wrong number % of row at pivot table

[coloful_architect]

Hi community,

I want to have a pivot table to show how much %  units for each business entity purchase from manufacturers.

I have this for my measurement: Sum([Pack Units])/sum(total<Manufacturer>[Pack Units])

when I click one particular business name, it returns

but it should be 50% vs 50% like this ; 

without selection, by default, it gives me % upon all manufacturer. so pretty much small weight like 1 or 2 % across all business.

what I miss? 

[kKoumoundouros · Accepted solution]

Try to change your expression measurement (the part of the total, instead Manufacturer use the Business Name

from Sum([Pack Units])/sum(total<Manufacturer>[Pack Units])

to Sum([Pack Units])/sum(total<[Business Name]>[Pack Units])