Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Pastrupgaard
Helper I
Helper I

create cumulated totals on specific customer without date

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

excel.JPG

 

Datasetexcel #2.JPG

Thank you in advance

1 ACCEPTED SOLUTION
V-lianl-msft
Community Support
Community Support

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))

Vlianlmsft_0-1625036418981.png

 

View solution in original post

3 REPLIES 3
V-lianl-msft
Community Support
Community Support

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))

Vlianlmsft_0-1625036418981.png

 

amitchandak
Super User
Super User

@Pastrupgaard , Try a measure like

 

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

Hi @amitchandak

 

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

 

excel #3.JPG

 

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

excel #4.JPG

Br
Patrick

 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors