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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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.


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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