How to sum the percentage in Power bi

[yiying]

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

[Phil_Seamark]

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?

[yiying]

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

[Phil_Seamark]

Like this?

[yiying]

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. 

[vega]

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?

[yiying]

Yes.

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

[vega · Accepted solution]

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: