The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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):
With sum applied to 'Test' (Issue - Total sum same for every period):
Applying Summation to field (Issue - Total sum same for every period):
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
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.
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.
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.
Hi Rico,
Thanks for reaching out. I've updated the post with more information.
Thanks in advance!
Josh
Hi
Can you share some more information. Sum with respect to another column? What do you mean "turn on sum"?
Thanks
Hari
Hi Hari,
I've updated the post with more information. Please let me know if I can share any more information.
Thanks,
Josh
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.
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