Forum Discussion
Reporting % in PowerBI
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 :-(
Try this create a measure that divides the sum of the gross profit into the sales:
Measure = Sum(Gross Profit) / Sum(Sales)
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.
4 Replies
Do you have summarization on for the field that represents GP%?
It sounds like it's adding the percentages together.
This is what I get when I click on the field.
Try this create a measure that divides the sum of the gross profit into the sales:
Measure = Sum(Gross Profit) / Sum(Sales)
