Incorrect SUM measure in table

[Tevon713]

Hi all... I have a simple table with account number and count field, I attempted to create simple measure. Not sure why it double when summing. Must be something simple, see below.  Each row it double sum, the correct should be half per SUM Count measure.. total should be 15.

SUM Count - SUM(Table1[Count])

[v-jayw-msft]

Hi @Tevon713 ,

What is [sum count] in table?

Try ISINSCOPE() and SUMX() function at total level.

Best Regards,

Jay

[Tevon713]

Thanks @v-jayw-msft.  Sum Count is a measure that summing up the "Count" of Table 1. 

Here's another look in matrix.

SUM Count = SUM(Table1[Count])