Forum Discussion

Kurtle's avatar
Kurtle
Helper II
6 years ago

Running Cumulative Percent

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!

 

 

Need Help

9 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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.

     

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    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's avatar
      Kurtle
      Helper II
      6 years ago

      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's avatar
        amitchandak
        Super User
        6 years ago

        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.