Forum Discussion
Pie Chart Issue
mork Your Numerator uses COUNTA (which ignores blanks) while your Denominator uses COUNTROWS (which counts ALL)
This is will definitely make the % not add up to 100% (if you have blanks) Convert your pie chart to a Table and Check
You have to be consistent either use COUNTA for both or COUNTROWS for both
Let me know if this takes care of it.
my measure is the following:
WorkDistributionPercentage = COUNTA ('Table'[TypeOfWork])/ CALCULATE (COUNTROWS('Table');ALL('Table'[TypeOfWork]))
This is filtered by work department and date. I get different percentages in my graph. When I remove the filters both percentages change and the difference becomes even bigger. For example what was 69.87% and 74.77% becomes 32.97% and 61.95%. The second percentage is the percentage that comes from the pie chart. Another thing that I noticed though is that in the pie chart the piece that represents the 32.97%/61.95% in size is closer to 61.95% which is really weird. How can my measure provide a number under 50% and the size of the piece of the pie be bigger that 50%?
Also anotehr thing that I noticed is that none of the two percentages add up to 100%. Though the default percentage from the pie chart comes closer at 99.84% while my measure's percentage is around 50%. I don't remember having that issue with my measure before the latest update.
mork Your Numerator uses COUNTA (which ignores blanks) while your Denominator uses COUNTROWS (which counts ALL)
This is will definitely make the % not add up to 100% (if you have blanks) Convert your pie chart to a Table and Check
You have to be consistent either use COUNTA for both or COUNTROWS for both
Let me know if this takes care of it.