Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Incorrect total

Hello -  The measure below is returning the correct amounts at the row level, but not at the total value level.  Any advice on how to correct?        Internal Use scale accrual % = SUM( Sh...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    PaulDBrown    I tried this approach, and it works perfectly.    I referenced my original measure, in this measure: 

    SUMX( VALUES( 'Date Table'[MonthnYear]), [Internal Use scale accrual] )
    Thanks for the help!

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

Anonymous 

Not sure why the SUMX(SUMMARIZE)) measure isn't working. The measure firstly creates a virtual table with the relevante columns by SUMMARIZE and computes the SUM (your measure for each row). Then SUMX kicks in to add the values computed by your measure to calculate the total. 
might be worth trying to include your measure as a VAR (which will compute the row values in memory) and the use the SUMX(SUMMARIZE()) as the RETURN. 

Or try calculating you measure as a seperate measure and use that measure in the SUMX(SUMMARIZE()) measure.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PaulDBrown    I tried this approach, and it works perfectly.    I referenced my original measure, in this measure: 

SUMX( VALUES( 'Date Table'[MonthnYear]), [Internal Use scale accrual] )
Thanks for the help!