Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Total Column not summing

Hello, I am trying to do a simple formula = Total * Rate. However, the total in the row does not work. Does anyone know how to change the formula so it totals properly, please? I understand its usi...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    Please try

    Test =
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[Name],
        Dates[Date]
    ),
    [Rate] * [Total]
)
AlexisOlson's avatar
AlexisOlson
Super User
3 years ago

You can iterate over companies instead of dates and/or you could fix your [Rate] measure. Rates aren't generally additive, so the 6.00% in the total row doesn't make sense.