cancel
Showing results for
Did you mean:
jessiew 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.
jessiew 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.

jessiew Frequent Visitor

## Re: Calculate cumulative percentage from a calculated column Super User

## Re: Calculate cumulative percentage from a calculated column

Hi,

You may refer to my solution in this PBIX file.

Hope this helps. jessiew Frequent Visitor

## Re: Calculate cumulative percentage from a calculated column

Thanks so much Ashish. It worked. Super User

You are welcome.