Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Why won't this column total?

Same syntax and logic for the columns that have totals at the bottom... table level as well as the visual are set to SUM.. however, this column isn't totaling right

Calc Stories Uncompleted = IF('Sprint Burndown'[Date].[Date] < 'Sprint Burndown'[Sprint End Date].[Date]
&& 'Sprint Burndown'[State Category] = "InProgress", 1,0)
 

 

Need Help

3 Replies

  • tackytechtom's avatar
    tackytechtom
    Icon for Most Valuable Professional rankMost Valuable Professional
    3 years ago

    Hi Anonymous ,

     

    I assume Calc Stories Uncompleted is a calculated column, correct?

     

    Have you chosen SUM in the column list in your visual? Like this one:

     

     

    Note, this is not a best practice, since this is creating a so called "implicit measure". A better way to do this is to create an explicit measure on your calculated column and then using this one in your visual.

     

    Let me know if this helps 🙂

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      It is a calculated column on a line graph so it will only aggregate I'm assuming. Are you saying create a measure and use that instead?