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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Column is not summing at the bottom, but when I turn on sum, all the values change to the total

I want it to show the total values by period with a complete total at the bottom of the table. 

 

Nothing applied (Issue - No Total):

JoshAnness_3-1655814208895.png

JoshAnness_0-1655814109575.png

With sum applied to 'Test' (Issue - Total sum same for every period):

JoshAnness_2-1655814180817.png

JoshAnness_1-1655814166187.png

Applying Summation to field (Issue - Total sum same for every period):

JoshAnness_7-1655814424432.png

JoshAnness_6-1655814306506.png

 

What I want:

Period          Test

1                   $5

2                   $4

3                   $3

4                   $2

5                   $5

6                   $3

7                   $1

8                   $2

9                   $5

10                 $3

11                 $2

12                 $5

13                 $6

Total             $46

6 REPLIES 6
Anonymous
Not applicable

Hi @Anonymous ,

 

According to your statement, I think "without sum" should be selecting "Don't summarize" function in value field, and "turn on sum" should be selecting "Sum" function in value field. 

RicoZhou_1-1655799630212.png

As far as I know, Power BI will expand the columns based on relationship and context. So this shuld be caused by your data model. As below, [Column2] will expand by [Column1] from same table and sum function works well.

RicoZhou_0-1655799583995.png

 

Please share a sample file with us and this will make it easier for us to find the solution.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Hi Rico,

 

Thanks for reaching out. I've updated the post with more information.

 

Thanks in advance!

Josh

Hariharan_R
Solution Sage
Solution Sage

Hi

Can you share some more information. Sum with respect to another column? What do you mean "turn on sum"?

 

Thanks

Hari

Anonymous
Not applicable

Hi Hari,

 

I've updated the post with more information. Please let me know if I can share any more information. 

 

Thanks,

Josh

Anonymous
Not applicable

Hi @Anonymous ,

 

I have checked your screenshot, and I have some questions about your data model.

I think your issue should be caused by your data model. Just like my sample as above, [Period] and [Test] in the same table or they are in two tables which have been connected by a relationship, SUM function in value field should work well.

So please share a sample file without sensitive data with me or show me more details about your tables and relationship.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Hi @Anonymous,

 

Thanks for getting back to me. Unfortunately, my organization does not allow me to share any pbix files outside the network. I've attached a video that should provide you with the necessary information.

 

Thanks again,

Josh

 

2022-06-22_8-07-55.gif

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.