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 using the total percentage to multiple the total total, but I am not sure how to change it to get the total in the row. Help please

 

Here is the formula I am using: 

Test =
    IF(
        HASONEVALUE(Dates[Date]),
        [Rate] * [Total] ,
            SUMX(Dates,
             [Rate] * [Total]
             ))

 

 

 

 

  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    Please try

    Test =
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[Name],
        Dates[Date]
    ),
    [Rate] * [Total]
)

3 Replies

  • 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.

  • 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!!!!!