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!

Johanno's avatar
Johanno
Continued Contributor
5 years ago

It probably returns the correct value, just not the value you expect. ðŸ˜Š

 

You should debug the code and see what the total row returns for the different parts (like MAX ( Shipments[Primary Customer2] ) - is that the logical value for the total row?).

 

Using VARiables would make it easier to debug and return different parts.

 

This might lead to that you need a variation of the code to get you the expected result on the total row, then maybe you can distinguish that with somehting like:
IF( HASONEVALUE(whateveryoufilteron), ResultForAFilteredRow, ResultForATotalRow)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.  

    • Johanno's avatar
      Johanno
      Continued Contributor
      5 years ago

      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.