Cumalative column (not measure)

[William_Moreno]

Hello everyone,
I need help to solver this problem! 

Unit Bussiness	Code	Value	Cumative Value
Chicago	100500001	50%	50%
Chicago	100500002	20%	70%
Chicago	100500003	15%	85%
Chicago	100500004	10%	95%
Chicago	100500005	5%	100%
Paris	100500001	50%	50%
Paris	100500002	20%	70%
Paris	100500003	15%	85%
Paris	100500004	10%	95%
Paris	100500005	5%	100%

I've tried to develop a function to create the column Cumulative Value in powerbi, but I  can't do this!
I need that cumulative as a column not as a measure.

Thanks in advanced.

[amitchandak]

@William_Moreno ,

A new column

Column = sumx(filter(Cumm, Cumm[Unit Bussiness] = EARLIER(Cumm[Unit Bussiness]) && [Code] <=EARLIER(Cumm[Code])),[Value])

New measure

Measure = sumx(filter(ALLSELECTED(Cumm), Cumm[Unit Bussiness] = max(Cumm[Unit Bussiness]) && [Code] <=max(Cumm[Code])),[Value])

[William_Moreno]

@amitchandak thanks for your post, but I forgot to mention the data are not organized from the top to the bottom, In this case, how can we solver this problem?

[richbenmintz]

Hi @William_Moreno ,

In Power Query, Sort your data so that it is ordered correctly, or create an index column and use that in your dax column