Reporting % in PowerBI

[Mike_Clishem]

Hi,

I'm new to PowerBI and I'm struggling with reporting percentages. I have a column for GP % as an example and when I slice my geographical areas then the GP% is shown correctly in a "card", however, when no area is selected the % reported is a huge number which makes no sense. Is it possible that without any row being selected that the reported GP% could be the total GP% for the reported period? I don't have a row for total sales and total gross profit. My data looks similar to this:

                           Sales                Gross Profit                Gross Profit %

Area 1                    100                          25                                  25.00%

Area 2                    200                          125                                62.50%

Area 3                    500                           350                               70.00%    

I would like to see the GP% across all areas when no single area is chosen within the slicer................does that make sense?

The reported GP% for the period for the example should be reported as 62.50% instead I get what appears to be the sum of the reported percentages i.e 157.50%!!

Frustrated!

Mike 😞 

[Watsky · Accepted solution]

Try this create a measure that divides the sum of the gross profit into the sales:

Measure = Sum(Gross Profit) / Sum(Sales) 

[Watsky]

Do you have summarization on for the field that represents GP%? 

It sounds like it's adding the percentages together.

[Mike_Clishem]

This is what I get when I click on the field.

[v-yuta-msft · Accepted solution]

@Mike_Clishem ,

You just need to create a measure as Watsky mentioned.

Gross Profit % = SUM('Table'[Gross Profit]) / SUM('Table'[Sales])

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Watsky · Accepted solution]

Try this create a measure that divides the sum of the gross profit into the sales:

Measure = Sum(Gross Profit) / Sum(Sales)