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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sandeepk66
Advocate I
Advocate I

Power BI Desktop Sum By Group

 Hi Power Geeks,

 

I am looking for Grouping by SUM,  And Sum for each dynamic group (Store ID),similar to SSRS or Crystal Reports.

Currently the Report looks like:

INVOICE

PRICE

Store ID

202303

4.381623

34

202303

641.7039

5

202303

641.7382

5

202303

3838.188

21

202303

5552.746

235

202303

5294.524

678

202303

524.124

678

 

And I want the output like:

INVOICE

PRICE

Store ID

202303

641.7039

5

202303

641.7382

5

TOTAL for 5

1283.442

 

202303

3838.188

21

TOTAL for 21

3838.188

 

202303

4.381623

34

TOTAL for 34

4.381623

 

202303

5552.746

235

TOTAL for 235

5552.746

 

202303

5294.524

678

202303

524.124

678

TOTAL for 678

5818.648

 

 

4 REPLIES 4
sandeepk66
Advocate I
Advocate I

Users wanted in Power BI Desktop,  All they needed is Totals for each Group. So, I need Grouping on Store ID and Sum By Price for each Store.So,Can we tweak atleats like below in Power BI Desktop?

 

INVOICE

PRICE

Store ID

202303

641.7039

5

202303

641.7382

5

 

1283.442

 

202303

3838.188

21

 

3838.188

 

202303

4.381623

34

 

4.381623

 

202303

5552.746

235

 

5552.746

 

202303

5294.524

678

202303

524.124

678

 

5818.648

 

@sandeepk66,

 

If the Matrix visual is not satisfying, you may use SUMMARIZE Function to add a calculated table.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ashish_Mathur
Super User
Super User

Hi,

 

I cannot get your desired result using Power BI desktop.  Using Excel, i can get a close enough result (see screenshot).  In Excel, i have used Power Query (the Index column has been generated using Power Query) and Pivot Tables to get your desired result.Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Greg_Deckler
Super User
Super User

Hmm, I can seem to get close with the new Table and Matrix but can't get it exactly like you want below, would be interested if anyone else can think of a solution.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors