Forum Discussion
paolomint
Helper III
Helper IIINo SUM for IF function
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 fi...
Thank for your reply,
I need an if function because I need sum on different column.
Anyhow I solved in SQL.
Bye
Paolo
amitchandak
Super User
Super Userpaolomint , 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])