Forum Discussion
Solved
No 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
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)
Thank for your reply,
I need an if function because I need sum on different column.
Anyhow I solved in SQL.
Bye
Paolo