Total Column not summing

[Kryssy]

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 · Accepted solution]

Hi @Kryssy 
Please try

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

[Kryssy]

Thank you very much!!!!!

[AlexisOlson]

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.