Forum Discussion
Anonymous
5 years agoNot applicable
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
- 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] )
Fowmy
5 years agoSuper User
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] )