How can I measure a percentage via many criterias?

[Anonymous]

Hi all,

I would like to calculate the percentage as sample below:

Geography	Method	Delivered
North	A	1000
South	B	2000
Central	C	1000
North	B	3000
South	A	2000
Central	B	3000

Let's say, I want to draw a column charge showing the percentage of Method A,B,C in North (which is 25%,75%,0% respectively). How should I do to get that measure?

Thanks for your help.

[Anonymous]

You haven't mentioned the total of delivered to calculate %. Suppose if it is 4000, 

Create the column and use following dax

Percentage = Sheet1[Delivered]/4000*100

Replace 4000 with the total amount.

Let me know if it works.

[Anonymous]

Not really...

the total of delivery should be the sum of all delivery for each method:

Method A: 4000

Method B: 8000

Method C: 1000

[Anonymous · Accepted solution]

I'm getting total of A is 3000 as per the data you provided. I dont know how you got 4000.

Anyway, 

if 3000 is correct count, try following dax.

Percentage = Sheet1[Delivered]/CALCULATE(SUM(Sheet1[Delivered]),ALLEXCEPT(Sheet1,Sheet1[Method]))*100