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]
)
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 
Please try

Test =
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[Name],
        Dates[Date]
    ),
    [Rate] * [Total]
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you very much!!!!!