cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User IV
Super User IV

Re: Power BI Desktop Sum By Group

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.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User IV
Super User IV

Re: Power BI Desktop Sum By Group

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/
Highlighted
Advocate I
Advocate I

Re: Power BI Desktop Sum By Group

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

 
Highlighted
Community Support
Community Support

Re: Power BI Desktop Sum By Group

@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.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors