No SUM for IF function

[paolomint]

Dear all,

please have a look below.

I'm using a IF function and I don not understand why it works correctly but the total ammount of the row is zero and not the sum of all the values.

How can I fix this?

Thanks in advance.

Paolo

[amitchandak]

@paolomint , refer to a suggestion by @Anonymous , or you have force row level total like

new measure =

Sumx(Summarize(Table, Table[Year], Table[Month], "_1", [Your Measure]) , [_1])

https://www.youtube.com/watch?v=ufHOOLdi_jk

[Anonymous]

Hi,
1- Show you complete dax function, also the refrenced measure.
2- Use Calculate function intead of if, to get the sum for filtered conditions, like this
calculate(sum('tablename'[columnname]),Condition 1 && Condition 2 ---------etc)

[paolomint · Accepted solution]

Thank for your reply,

I need an if function because I need sum on different column.

Anyhow I solved in SQL. 

Bye

Paolo