Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
singleton2787
Helper III
Helper III

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)
 

singleton2787_0-1665000423184.png

 

1 ACCEPTED SOLUTION

Hi @singleton2787 ,

 

Yes, that is what I would generally recommend. Create a measure like SUM ( Table[Column] ).

 

Hope this helps 🙂

 

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



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

3 REPLIES 3
tackytechtom
Super User
Super User

Hi @singleton2787 ,

 

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

 

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

 

tomfox_0-1665001218838.png

 

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/

 

 

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

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? 

Hi @singleton2787 ,

 

Yes, that is what I would generally recommend. Create a measure like SUM ( Table[Column] ).

 

Hope this helps 🙂

 

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



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.