Forum Discussion
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...
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!
Thanks Johanno Normally I would agree but in this case, the values I need to see summed up are the exact ones showing on the rows. The total is showing the sum of the aggrated shipped price * the max incentive. I just need a sum that totals up exactly what is showing in those rows.
Ok, can you try to encapsulate the expression with SUMX ( the table you want to iterate with the column in your table, the expression). If this doesn't help I would be great with some sample data to work with.