power bi shows the sum wrong

[divya_jain]

i wan to attach a picture of the table.

[divya_jain]

the 'total' row auto calculated by power bi shows: total $45000 for the last column. it should be $55000!

[divya_jain]

Team ID Level ID Role Name Rep Name Product ID Weight % Target by Product ($) Team 1 L1 Sales Representative John Doe MBO 40% $4,000 Team 1 L1 Sales Representative John Doe P1 40% $4,000 Team 1 L1 Sales Representative John Doe P3 20% $2,000 Team 1 L1 Sales Representative Ram Sharma MBO 40% $4,000 Team 1 L1 Sales Representative Ram Sharma P1 40% $4,000 Team 1 L1 Sales Representative Ram Sharma P3 20% $2,000 Team 1 L2 Area Manager Alice Du MBO 40% $6,000 Team 1 L2 Area Manager Alice Du P1 40% $6,000 Team 1 L2 Area Manager Alice Du P3 20% $3,000 Team 1 L3 Region Manager Jack Lim MBO 40% $8,000 Team 1 L3 Region Manager Jack Lim P1 40% $8,000 Team 1 L3 Region Manager Jack Lim P3 20% $4,000