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 double sum, the correct should be half per SUM Count measure.. total should be 15.

 

SUM Count - SUM(Table1[Count])

 

Need Help

2 Replies

  • 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])