Power BI Desktop Sum By Group

[sandeepk66]

 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

[sandeepk66]

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

[v-chuncz-msft]

@sandeepk66,

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

[Ashish_Mathur]

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.

[Greg_Deckler]

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.