IF not Summing

[SpeckyD]

Hi. Hoping someone can help. 
I have a few measures in my report which all have a total sum at the bottom of the list. 
My last measure looks at one of the last measures and does an IF statement to see if it is 0. If so it gives it a 1. If not it gives it a 0. This works fine at the row level and shows the 0 or 1 value correctly. However the total for the column just shows a 1. I would expect it to do a sum and show 500+. I've tried a sum on the measure but it doesn't allow it. I've tried setting the value to number and no luck. Out of ideas......

[Anonymous]

Hi @SpeckyD ,

It sounds like you are trying to create a calculated column in your report that checks if a certain measure is equal to 0, and then returns a 1 or 0 accordingly. However, when you try to sum up this calculated column, you are only getting a value of 1 instead of the expected sum. One possible solution is to use a DAX measure instead of a calculated column.

Best regards.
Community Support Team_Caitlyn