Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
djurecic's avatar
djurecic
Super User
3 years ago

Hi Anonymous ,

 if the goal is to Sum the values, would you consider changing the data type to integer?

 

I think you might need to use Count instead of sum and filter on value=1

  • ghaines's avatar
    ghaines
    Resolver I
    3 years ago

    Based on the name of the column in the visual, it looks like advanceCarePlanCompleted is a column within a project table that is set to 0 or 1.  If you used count for this column, the result would always be blank, 1 or 2.

     

    But I just think we're fumbling in the dark unless the poster adds more details.