Sum of rows and expression total are different

[#1]

I have  below expression in Bar chart and Straight table...in straight table when I sum the rows I get different numbers and in bar chart I get different numbers however when I do expression total in straight table they match.

How  can I do the same sum in bar chart ?

(if(ABRBuildingCode =  'THOM-B5635',22,

IF(Capacity-((count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='OFFICE',

              UniqueAB2Key)))

                          +

      count(if(len([EM EmpName])=0,

          IF([RoomTypeAssigned]='WRKST',

              UniqueAB2Key))))) = 0

or COUNT(distinct (UniqueAB2Key)) =0,

     sum([AB1BuildingCpacity(Manual)]),

      COUNT(distinct (UniqueAB2Key)))))

[sunny_talwar]

Would you be able to provide some sample raw data to test this out?

[#3]

I have 5 files linked together....and the data is huge even for 1 ID...