topic Re: Total Column not summing in DAX Commands and Tips

Total Column not summing

Anonymous — Mon, 16 Jan 2023 03:28:52 GMT

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]

))

Re: Total Column not summing

AlexisOlson — Mon, 16 Jan 2023 04:05:42 GMT

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.

Re: Total Column not summing

tamerj1 — Mon, 16 Jan 2023 07:45:08 GMT

Hi Anonymous
Please try

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

Re: Total Column not summing

Anonymous — Mon, 16 Jan 2023 13:06:00 GMT

Thank you very much!!!!!