cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jessiew Frequent Visitor
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?

Excel calculation.pngPowerBI measure.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Calculate cumulative percentage from a calculated column

Hi,

 

You may refer to my solution in this PBIX file.

 

Hope this helps.

 

Untitled.png

8 REPLIES 8
Super User
Super User

Re: Calculate cumulative percentage from a calculated column

Hi,

 

Please share the download link of the Excel file that you have pasted in the screenshot.

Community Support Team
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] ) )
)

Capture.PNG

 

You could have a reference of the formula above.

 

Hope this can help you!

 

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

https://drive.google.com/open?id=1EYU9r_EUvXIXpmrMcwqRkh5iivuDgRyT

 

The pbix file is at below link:

https://drive.google.com/open?id=1T3wi2ENCwqAelFUmxbsftFEtFGRE8a2M

 

Super User
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
Frequent Visitor

Re: Calculate cumulative percentage from a calculated column

Hi 

 

 

 

 

 

 

 

Super User
Super User

Re: Calculate cumulative percentage from a calculated column

Hi,

 

You may refer to my solution in this PBIX file.

 

Hope this helps.

 

Untitled.png

jessiew Frequent Visitor
Frequent Visitor

Re: Calculate cumulative percentage from a calculated column

Thanks so much Ashish. It worked. 

Super User
Super User

Re: Calculate cumulative percentage from a calculated column

You are welcome.