cancel
Showing results for
Did you mean:
Frequent Visitor

## Calculate cumulative percentage from a calculated column

Hi,

I would like to calculate the Cumulative Qty% like it shows in the excel spreadsheet below. I created a measure for the calculation. But the calculation doesn't seem to be accurate. Can someone point me what is wrong with my measure?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Calculate cumulative percentage from a calculated column

Hi,

You may refer to my solution in this PBIX file.

Hope this helps.

8 REPLIES 8
Super User

## Re: Calculate cumulative percentage from a calculated column

Hi,

Community Support Team

## Re: Calculate cumulative percentage from a calculated column

Hi @jessiew,

I'm not clear about your sample data so I made a test with a sample data similar with yours, but I add an Index column to calculate the cumulative percentage.

```Measure =
CALCULATE (
SUM ( 'Table1'[Column] ),
FILTER ( ALL ( 'Table1' ), 'Table1'[Index] <= MIN ( 'Table1'[Index] ) )
)
```

You could have a reference of the formula above.

Best Regards,

Cherry

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

## Re: Calculate cumulative percentage from a calculated column

Hi,

The excel spreadsheet Sheet 4 indicates the calculation of the cumulative qty%. See below link for the share:

The pbix file is at below link:

Super User

## Re: Calculate cumulative percentage from a calculated column

Hi,

Reduce the file size to a few kb's only.  Also, whenever you share a download link, always mention the file size if it it more than 1 MB.  How will i otherwise know the size of the file that i am downloading.

Frequent Visitor

Super User

## Re: Calculate cumulative percentage from a calculated column

Hi,

You may refer to my solution in this PBIX file.

Hope this helps.

Highlighted
Frequent Visitor

## Re: Calculate cumulative percentage from a calculated column

Thanks so much Ashish. It worked.

Super User

## Re: Calculate cumulative percentage from a calculated column

You are welcome.

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 133 members 1,956 guests
Recent signins: