PowerBI - Percentage not adding up

[hmltnangel]

OK, bit of an odd one here. Everything seems to work on my PowerBI file except for one thing.

I have a Table - with a column for average staff in each office. There is a PBI Measure - Corrected Average - which basically sums the averages to give a Total Average for the Country.

Corrected Average = sum(Headcounts[Headcount Average])

There is also a table for all leavers in the business. I also have another measure, which works out the percentage of leavers against the total average staff

ATTRITION V1 = Divide(counta(Terminations[Emplid]),(headcounts[corrected average]))

Now, to show the leaver percentages, I have some cards, which show the leaver percentages as follows:

Card 1 - Total Leavers
Card 2 - Type 1 Leavers
Card 3 - Type 2 Leavers

Now this is where it gets interesting: The percentages are as follows:

Card 1 - 21.003% (229 leavers)
Card 2 - 17.333% (189 Leavers)
Card 3 - 3.877% (40 leavers)

Total Average Staff is 1090

Now, correct me if I am wrong, but 3.877+17.333 is not equal to 21.003? I cannot find anything to cause this. Any suggestions? I am stumped

 

[RoryA]

The type2 figure is definitely not a percentage of 1090. 40 out of 1090 is more like 3.67%

 

[hmltnangel]

Exactly Rory, I have no idea why. interestingly I have tried copying to a new PBIX file and it works perfect. Could there be some random filter or Visual affecting it somehow?

 

[RoryA]

That seems a likely option, especially if it works properly in a new 'vanilla' file.

 

[hmltnangel]

Yep, works in a new file. Any way to find the mystery cause?

 

[hmltnangel]

Well, it seems like it was a single visual on another tab that was affecting this. No idea why, but deleted that visual and rebuilt from scratch, and everything works perfect now.