cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## How can I measure a percentage via many criterias?

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I

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
3 REPLIES 3
Highlighted
Helper I

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.
Highlighted
Frequent Visitor

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

Highlighted
Helper I

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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors
Users online (707)