Forum Discussion
SUM function not working
I have a column (advancecareplancompleted)that has binary values- 0,1. I want to sum all the rows to get the total number of 1s. However, power BI returns total as 1. What should I need to do. I trie...
daXtreme
Solution Sage
Solution SageWhat measure did you create then? You should show us all the things that are relevant to the problem at hand. Hiding details is not the best strategy. What does it mean "binary values"? What type are they? If they're integers, then the measure is simple: SUM( T[Value] ). And that's all you need. If this does not work, then your model is most likely dodgy in some way.