Pie Chart Issue

[mork]

I have created a measure that shows the work distibution of my resources in precentage. I use this measure in a pie chart and it shows up fine.

But after the latest updated they added percentage distribution on the pie chart by default. Now my pie chart shows two different percentages. One from my measure and the other from the chart inside brackets. The thing is though that the two perventages are different.

For example my measure shows a 69.87% percentage while the brackets show a 74.77% percentage. The same goes for the rest of my data, 15.28% and 16.36%, 2.18% and 2.34% etc.

Why is that?

[Sean]

You measure most likely doesn't take into account some filter applied to the pie chart.

But without any details - who knows...

[mork]

@Sean

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%?

[mork]

@Sean

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.

[Sean · Accepted solution]

@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.

[mork]

@Sean

You are correct that was the problem