cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How can I measure a percentage via many criterias?

Hi all,

I would like to calculate the percentage as sample below:

 

GeographyMethodDelivered
NorthA1000
SouthB2000
CentralC1000
NorthB3000
SouthA2000
CentralB

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

View solution in original post

3 REPLIES 3
Highlighted
Helper I
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.
 
Untitled.png
 
 
Let me know if it works.
Highlighted

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

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

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)