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], ...
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.