cancel
Showing results 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

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

Dataset

1 ACCEPTED SOLUTION
Community Support

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

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

3 REPLIES 3
Community Support

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

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

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

Helper I

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors