Cumulative sum by column no date

Question

Hi, i have a little problem unsolved with a dax cumulative.&nbsp;i have this table&nbsp;CategoryValueA1A1B1C1C1D1&nbsp;I need to create a cumulative sum by category&nbsp;So the result is this:&nbsp;Category SumValues CumulativeA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2C &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5D &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6Total &nbsp; &nbsp; &nbsp; 6&nbsp;&nbsp;How can i calculate the cumulative?&nbsp;Thanks for help&nbsp;

v-qiuyu-msft · Answer

Hi Vvelarde,
&nbsp;
In your scenario, why do you want to get the result based on the sorting A-&gt; C-&gt; B-&gt; D. If we Group By based on Category&nbsp;in Query Editor, we can't sort by SumValues firstly then by Category. If we based on the normal category sorting, we can add a index column to calculate the running total easily.
&nbsp;
Best Regards,
Qiuyun Yu

vvelarde · Answer

hi&nbsp;v-qiuyu-msft&nbsp;I need to show order the category (A,B,C,D) by Sum of values. To Show Correctly a Cumulative Sum..Starting from Highest to Lowest.&nbsp;&nbsp;My next step is show a measure &nbsp;in %.&nbsp;A &nbsp; 2 &nbsp; &nbsp; (2/6)C &nbsp; 2 &nbsp; &nbsp; (4/6)B &nbsp; 1 &nbsp; &nbsp; &nbsp;(5/6)D &nbsp; 1 &nbsp; &nbsp; &nbsp;(6/6)Total 6&nbsp;This is the reason of i don't show you in normal sorting

vvelarde · Answer

I had these measure that works when the sum of values is different by each category.&nbsp;ValuesAcumulado = 
VAR valor=Calculate(Sum(Table1[Values])
RETURN
SUMX(FILTER(All('Category');[SumaValues]&gt;=valor);[SumaValues])Where Category is a single table column with A,B,C,D and SumaValues = Calculate(Sum(Table1[Values]))&nbsp;The problem is when have &nbsp;same sum values for 2 or more categories. The Sum takes all the categories with same values.&nbsp;

anonymous · Answer

Hi&nbsp;Vvelarde&nbsp;Here &nbsp;is how I did.&nbsp;1. Created a Summarized table Table5 with columns Category as &nbsp;Cat &nbsp; and sum Values &nbsp;- Result from source table.2. Created a running sequence number column using&nbsp; &nbsp; &nbsp;IndexCat = CALCULATE(COUNTA(Table5[Cat]), FIlter(Table5,Table5[Cat]&lt;=EARLIER(Table5[Cat])))3. Created a Rank column&nbsp;&nbsp; &nbsp;&nbsp;ModRank = RANKX(ALL(Table5), [Result]+[IndexCat]/100000,,0,Dense)4. By adding IndexCat/100000 there will be no two values with same Rank even though the value of Result is the same.5. Created a **bleep** total column&nbsp; &nbsp;&nbsp;CumTot = CALCULATE(sum(Table5[Result]), FIlter(Table5,Table5[ModRank]&lt;=EARLIER(Table5[ModRank])))6. the output I got in a table format is&nbsp; &nbsp;&nbsp;The only issue I could not resolve yet is to get the Cat in the ascending order of cat within same values of Reult.May be you could throw some light on it.&nbsp;Cheers&nbsp;CheenuSing&nbsp;&nbsp;&nbsp;

Forum Discussion

Cumulative sum by column no date

4 Replies

Related content

Year to date cumulative

Cumulative Total

Find Most Recent Date Relative to another Date Column in Power Query

Progressive Date Columns

Cumulative Count by Date

Category	Value
A	1
A	1
B	1
C	1
C	1
D	1