Forum Discussion
Pbiuserr
Post Prodigy
Post ProdigyPie chart gives wrong results
I have a calculation
% of ontime =
VAR _Prc =
DIVIDE (
CALCULATE (
[CountOfOrders],
'table'[status] = "Ontime"
),
[CountOfOrders],
0
)
RETURN
IF ( _Prc = BLANK (), 0, _Prc )
and a pie chart where I've put Status as legend and CountOfOrders and value, went into detailed labels and choose datevalue, percentage. and the distribution is bad! Integers are okay but % not 2640/4088 is 64.58%, not 57,57%. My goal is to align the KPI with % of OnTime with percentages on a chart, and keep integers values as well. If I go to CountOfOrders and "show as grand total" the % are good, but in the tooltip it shows % on data value. Is there a way? Filter context is the same
2 Replies
Alf94Solution Supplier
Hello,
From what I see you have more than 4088 orders in your piechart (2640 + 1035 + 911 = 4586), that's why your percentage is not the same (2640 / 4586 = 57.5%) as in the KPI. Are you sure you do not have different filters applied on your KPI and your pie chart?
I have this issue also. What I find is that if you count the unique values of the Status, that is the total the pie chart is calculating against, not the number of orders.
For example, if I had the following:
order# Status 123 A 123 B 456 A I would calculate the denominator as the distinct count unique order = 2 and expect %A = #A / 2
The pie chart is calculating the denominator as the count of Status = 3 and then #A/3
Hope that makes sense.
