cancel
Showing results for
Did you mean:
Regular Visitor

## How to sum the percentage in Power bi

Here is a example of what I want to do.

Month       Location   Local sales      Total Sales        Percentage

May                NYC            10                  100                     10%

May                LA               10                  100                     10%

June               NYC             20                  100                     20%
June                 LA               20                  100                    20%

July                  LA               30                  100                     30%

Aug                  LA              40                  100                    40%

I was doing a barchart using location as  X-axis and using Month as slicer.  If I want to see the percentage for total month, it should be Sum(Local sales)/sum(total sales) instead of just suming up all the percentages. How should I do that? Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: How to sum the percentage in Power bi

Okay, you have the answer in your first post. You can create a measure like so:

```Answer =
SUM(Table1[Local Sales])/SUM(Table1[Total Sales])```

Then you can create a bar graph with the values as [Answer], Location as the axis, and a slicer with Month as value.
It will produce the following:

7 REPLIES 7
Super Contributor

## Re: How to sum the percentage in Power bi

Hi @yiying

So just to clarify, what would you expect to see if your user selects May in the slicer based on your sample data?

Proud to be a Datanaut!

Regular Visitor

## Re: How to sum the percentage in Power bi

A Barchart with just two bar:LA and NYC. Both showing 10%.

Super Contributor

## Re: How to sum the percentage in Power bi

Like this?

Proud to be a Datanaut!

Regular Visitor

## Re: How to sum the percentage in Power bi

Yes. Selecting a single month is not a problem. When I select all the percentage become crazy because it just add up all the percentage.

Member

## Re: How to sum the percentage in Power bi

What exactly do you expect to see when all months are selected? The Sum of the local sales divided by the sum of the total sales?
So, in the example you gave us, LA would be 100/400 = 25%.

Am I understanding this correctly?

Regular Visitor

## Re: How to sum the percentage in Power bi

Yes.

Or group by month. The percentage of July and Aug would be 70/200

Member

## Re: How to sum the percentage in Power bi

Okay, you have the answer in your first post. You can create a measure like so:

```Answer =
SUM(Table1[Local Sales])/SUM(Table1[Total Sales])```

Then you can create a bar graph with the values as [Answer], Location as the axis, and a slicer with Month as value.
It will produce the following:

Announcements

Power BI Super User, Greg Deckler, explains

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 47 members 930 guests
Recent signins: