Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sum for New Measure value only

Hi Team,   I have Total Sum from New Measure value, However grand total value should 5 but it shows 28 (grand total).   can you help me.   Thanks, KV's
  • Fowmy's avatar
    5 years ago

    Anonymous 

    The "Total Sum" Mesure has to be included with SUMX, for example:

    New Measure = 
    sumx ( table , [Total Sum] )
    or
    sumx ( values(table[Months]) , [Total Sum] )