create cumulated totals on specific customer without date

[Pastrupgaard]

Hi,

I'm struggeling to create cumulated totals on customers. I've made the following in Excel to help show what columns i have and how i would like to see it:

Example

Dataset

Thank you in advance

[V-lianl-msft · Accepted solution]

Please try:

_percentage = 
 DIVIDE(SUM('Table'[Value]),CALCULATE(SUM('Table'[Value]),ALL('Table')))

cumulative = 
var selected = MAX('Table'[#])
return CALCULATE([_percentage],FILTER(ALLSELECTED('Table'),'Table'[#]<=selected))

[amitchandak]

@Pastrupgaard , Try a measure like

divide(calculate(sum(Table[Value]), filter(allselected(Table), Table[Customer]<=Max(Table[Customer]))),calculate(sum(Table[Value]), allselected(Table)))

[Pastrupgaard]

Hi @amitchandak

I tried your formula and the this is the results  - any suggestions for tweaks?

I can see it's sorting based on the name (A-Z) instead of the value

Br
Patrick