Running Total measure/Column on multiple unsorted columns

[Anonymous]

I need help in creating a measure which can calculate running total for selected data in a table with unsorted columns as multiple group by are involved.
Business requirement is to have oil at the top always which is mostly positive value to start by and then calculte the running total for all other columns. It use to work early in SSRS(oracle as a source) using over parition by and order by the columns.Query was -

SUM(quantity) over (partition by item,place,Plan order by date,item,place, decode(item_type, 'Oil', 1,99), order_number,order_line)

In power bi i need to do it interactively and always it will be having a single item and place but multiple dates, item_types,order numbers and order_lines.
Currently my formula is giving duplicate while item type is same ,my Formula is:

Please help me in creating a measure  to achieve this. Do let me know if you need more details

Thanks
Amit

Item	Place	Date	Item Type	ORDER_NUMBER	Order Line	oval	Quantity	r total1	Expected Output
78801	America	7/8/2020	Oil		11	1	199390	199390	199390
78801	America	7/9/2020	Food	Material	12	3	-15240	184150	184150
78801	America	7/10/2020	Sports	137613	14	7	4800	188950	188950
78801	America	7/11/2020	Sports demand	103674	15	8	-1590	184531	187360
78801	America	7/12/2020	Sports demand	103695	11	8	-3	184531	187357
78801	America	7/13/2020	Sports demand	106984	32	8	-2420	184531	184937
78801	America	7/14/2020	Sports demand	137634	34	8	-89	184531	184848
78801	America	7/15/2020	Sports demand	137635	21	8	-89	184531	184759
78801	America	7/16/2020	Sports demand	137636	101	8	-89	184531	184670
78801	America	7/17/2020	Sports demand	137637	113	8	-89	184531	184581
78801	America	7/18/2020	Sports demand	82435354	32	8	-50	184531	184531
78801	America	7/19/2020	Sports	137614	10	7	4800	193750	189331
78801	America	7/20/2020	Sports demand	82195121	32	8	-633	183758	188698
78801	America	7/21/2020	Sports demand	103675	45	8	-2394	183758	186304
78801	America	7/22/2020	Sports demand	103696	6	8	-2	183758	186302
78801	America	7/23/2020	Sports demand	106985	8	8	-276	183758	186026
78801	America	7/24/2020	Sports demand	137638	45	8	-143	183758	185883
78801	America	7/25/2020	Sports demand	137639	343	8	-143	183758	185740
78801	America	7/26/2020	Sports demand	137640	45	8	-143	183758	185597
78801	America	7/27/2020	Sports demand	137641	65	8	-143	183758	185454
78801	America	7/28/2020	Sports demand	137642	45	8	-143	183758	185311
78801	America	7/29/2020	Sports demand	137643	33	8	-143	183758	185168
78801	America	7/30/2020	Sports demand	82435355	45	8	-235	183758	184933
78801	America	7/31/2020	Sports demand	82435356	90	8	-235	183758	184698
78801	America	8/1/2020	Sports demand	82435357	9	8	-235	183758	184463
78801	America	8/2/2020	Sports demand	82435358	45	8	-235	183758	184228
78801	America	8/3/2020	Sports demand	82435359	89	8	-235	183758	183993
78801	America	8/4/2020	Sports demand	82435360	45	8	-235	183758	183758

[Greg_Deckler]

@Anonymous - Is the data posted source data or expected output. Whichever one it is, post the other as well please.

Please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

Changed the data, i need to go from r total to expected output