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,

Highlighted
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.

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

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

#### PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 179 members 2,525 guests
Recent signins: