Using DAX Sum of Sales by Store ID in Power BI Desktop

[sandeepk66]

Hi, Can we Group by Totals sales by Location for Store ID Column in  Power BI Desktop, Please find the examples below.

Here is the Report:

Sales ID	Total Sales	Store ID
303	500	221
202	1200	560
102	700	221
232	400	780
103	450	120
231	555	780

And I want the output like:

Here, I needed Total Sales Grouping for Each Store, in the above example, Total Sales Grouped for Store ID’s 221 as 1300 &for 780 Total Sales 955.

Sale ID	Total Sales	Store ID
102	700	221
202	500	221
	1300
103	450	120
	450
303	1200	560
	1200
231	555	780
232	400	780
	955

[v-jiascu-msft]

Hi @sandeepk66,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[Anonymous]

Hi,

if you want to show this in a Dashboard then use Matrix Visual it serves just that.

Thanks

Yash

[koushikB]

You can also use calculated table for this, 

Go to Modeling tab and click on new table then use this DAX formula

Group by = SUMMARIZE(Sheet1,Sheet1[Store ID],"Total sales", Sum(Sheet1[Total Sales])). 

[vik0810]

You can use matrix visual.

[sandeepk66]

Can you provide steps, how did you get the row for totals under Store ID??

[vik0810]

assuming you put down your visual, added store id and sales id under rows and sum under value, use "expand all button", its in the left up corner, 3rd one.