Forum Discussion
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
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] )
1 Reply
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] )