Running Cumulative Percent

[Kurtle]

Hi team, 

I am trying to get a running percent using a meaure here. What I would like to do is get a cumulative percent of Gross Gath Gas when sorted by GOR. Both GOR and Gross Gath Gas are measures. Any ideas? 

Thank you in advance!

[v-easonf-msft]

Hi  , @Kurtle 

Sorry for that I am not sure what you want.
Isn't 6.25 your result？Or you want to show it as a percentage?

If it is the former, I hope you can show the results you want .It will be better to understand your problem.

If it is the latter, you can use the percentage format button directly for measure as below:

Best Regards,
Community Support Team _ Eason

[Kurtle]

@v-easonf-msft 

Sorry for the poor explanation... I would like to have a cumulitive percentage of the Gas when the table is sorted in descending order by GOR. See the picture below. Normally I would not have a problem doing this with a date but the GOR column is a Measure and all rows are from the same week. So I am unsure what to use as a index column to follow something like such as this. 

[amitchandak]

Try measures like this

cumm total =Calculate(Sum(Table[GOR]),filter(all(Table),table[UWI]<=max(table[UWI])))
GT =Calculate(Sum(Table[GOR]),all(Table))

Cumm % =divide([cumm],[GT])

Appreciate your Kudos.

[Kurtle]

@amitchandak I am unsure how to do this since the GOR colum is a measure so it will not allow me to sum it

cumm total =Calculate(Sum(Table[GOR]),filter(all(Table),table[UWI]<=max(table[UWI])))
GT =Calculate(Sum(Table[GOR]),all(Table))

[amitchandak]

cumm total =Calculate((Table[GOR]),filter(all(Table),table[UWI]<=max(table[UWI])))
GT =Calculate((Table[GOR]),all(Table))

Or share the formula for GOR

[Kurtle]

@amitchandak 
The formula for GOR is:

GOR = IFERROR(([Gross Gath Gas E3M3/D]*1000)/[Gross Gath Oil M3/D],BLANK())

Both 
Gross Gath Gas E3M3/D and Gross Gath Oil M3/D are measures with the formulas
Gross Gath Gas E3M3/D = Sum(Gross Gath Gas E3M3)/NumDays

Gross Gath Oil M3 =  Sum(Gross Gath Oil M3)/NumDays

[amitchandak]

I doubt on GT , but cumm should work

cumm total =Calculate(Sum(Table[GOR]),filter(all(Table),table[UWI]<=max(table[UWI])))
GT = sumx(summarize(all(Table),Table[table[UWI]],"_gor",[GOR]),[_gor])

[Kurtle]

I get the following error message when trying that

[amitchandak]

You can use quick measure, there you have option for running total use that.

For GT use

GT =Calculate(Sum(Table[GOR]),all(Table))

Divide 2.

Appreciate your Kudos.