Sum selected values based on another column and present as subtotals for another/ third column

[aks24]

Hi All,

Fairly new to powerbi so this may seem like a basic question but I cant seem to get my head around it. I have the following dataset showing order, order type, order category and amount.  I want to do 2 things to present my table and chart visual.

1. I would like to do sum based on selected values of order type (multiple values; in this case A+B+C) and separately by D.

2. These sum totals need to be presented by order category in the visual.

Any help is greatly appreciated. Cheers

Sample Dataset:

Order	Order type	Order Category	amount
123	A	Shirt	64654
23434	B	Tee	21465
345	A	Pants	56465
5476	A	Pants	68746
547	B	Tee	64654
342	D	Shirt	52465
8765	D	Shirt	54545
48	D	Tee	32415
2456	C	Pants	14533
2764	D	Pants	45646
68576	D	Pants	34563

Trying to achieve the following:

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI fille from here.

Hope this helps.

[aks24]

Thankyou! It works perfectly. Didnt think of this solution. 🙂

[Ashish_Mathur]

You are welcome.