Forum Discussion

Tevon713's avatar
Tevon713
Icon for Helper V rankHelper V
3 years ago

Incorrect SUM measure in table

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 doubl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Tevon713 ,

 

What is [sum count] in table?

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

 

Best Regards,

Jay

Tevon713's avatar
Tevon713
Icon for Helper V rankHelper V
3 years ago

Thanks Anonymous.  Sum Count is a measure that summing up the "Count" of Table 1. 

 

Here's another look in matrix.

 

SUM Count = SUM(Table1[Count])