cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## cumulative table

Hi looking to find an easy way to turn the table below into a cumulative table

1 ACCEPTED SOLUTION
Community Support

hi, @Anonymous

You could just use formula like below to create a cumulative measure

``````Cumulative =
CALCULATE (
expression,
FILTER ( ALL ( YourTable ), YourTable[Bucket] <= MAX ( YourTable[Bucket] ) )
)``````

here are related blogs for you refer to:

https://www.daxpatterns.com/cumulative-total/

https://javierguillen.wordpress.com/2012/11/28/running-total-techniques-in-dax/

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Anonymous
Not applicable

i am looking to find a way to make this table cumulative so on the left side we have number of users and the bottom we have number of days. I want a way to say 0 = 22% rather than 1=3% it should be 1=25%

Responsive Resident

Take a look at the cumulative total pattern.

https://www.daxpatterns.com/cumulative-total/

```Cumulative Quantity :=
CALCULATE (
SUM ( Transactions[Quantity] ),
FILTER (
ALL ( 'Date'[Date] ),
'Date'[Date] <= MAX ( 'Date'[Date] )
)
)```
Community Support

hi, @Anonymous

You could just use formula like below to create a cumulative measure

``````Cumulative =
CALCULATE (
expression,
FILTER ( ALL ( YourTable ), YourTable[Bucket] <= MAX ( YourTable[Bucket] ) )
)``````

here are related blogs for you refer to:

https://www.daxpatterns.com/cumulative-total/

https://javierguillen.wordpress.com/2012/11/28/running-total-techniques-in-dax/

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors