Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 😞
Solved! Go to Solution.
Try this create a measure that divides the sum of the gross profit into the sales:
Measure = Sum(Gross Profit) / Sum(Sales)
Proud to be a Super User!
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.
Do you have summarization on for the field that represents GP%?
It sounds like it's adding the percentages together.
Proud to be a Super User!
This is what I get when I click on the field.
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.
Try this create a measure that divides the sum of the gross profit into the sales:
Measure = Sum(Gross Profit) / Sum(Sales)
Proud to be a Super User!
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |